----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: _SQL_Vinod_ Message 5 in Discussion Here is yet another implementation using corelated subqueries. This is slightly better than the other implementation. We have both the query answered in the below code block. Create table vin_temp ( id Int Identity(1,1), Num Int) Insert into vin_temp values (10) Insert into vin_temp values (15) Insert into vin_temp values (20) Insert into vin_temp values (30) Insert into vin_temp values (40) Insert into vin_temp values (45) GO Select * from vin_temp a Where 2 = (Select Count(*) from vin_temp b Where a.num > b.num) GO Select * from vin_temp a Where (Select Count(*) from vin_temp b Where a.num > b.num) Between 2 and 5 HTH, Vinod Kumar MVP-SQL Server www.ExtremeExperts.com ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
