Lab Sql

I have created a subquery as follows select hospital.hospitalcode, name, wardno, annualbudget from … Read more Sql Sub-query - How To Find A Min Value

I am using SQL server 2005, querying with Web Developer 2010, and the min function appears to be re… Read more Sql Min() Returns Multiple Values?

I want to use min & max function but on certain criteria. Create Table #Test (Id Int Identity(… Read more Min() And Max() Based On Partition In Sql Server

I have a table for recording daily price from different suppliers. My goal is to find the best (low… Read more Showing Distinct Values With Aggregates

I have a table inquiry with columns job, gender (TRUE for women, FALSE for men) and salary. None of… Read more Unique Results For Sql Command With Group, Min And Null Values

I have a table inquiry with columns job, gender (TRUE for women, FALSE for men) and salary. None of… Read more Unique Results For SQL Command With GROUP, MIN And NULL Values