Thursday, November 29, 2007

Nth max in sql server



select * from tbl_pmis_projectschedule e where 3=
(select  count(distinct effort) from tbl_pmis_projectschedule where e.effort<=effort);

0 comments: