| Author: Arun Jacob 30 Nov 2008 | Member Level: Gold | Rating:  Points: 3 |
Select * from
(Select *,ROW_NUMBER() OVER(ORDER BY EmployeeID) as RowNumber from Employee)Temp
where RowNumber BETWEEN 2 AND 4
:-)
Arun Jacob
http://codenet.co.nr/
|
| Author: Deepika Haridas 30 Nov 2008 | Member Level: Diamond | Rating: Points: 3 |
Hi,
Select TOP 10 * from(Select *,ROW_NUMBER() OVER(ORDER BY EmployeeID) as RowNumber from Employee)Tempwhere RowNumber BETWEEN 2 AND 4
Regards,
deepika
++++
Thanks & Regards,
Deepika Haridas
DNS MVM
Please Rate this Response if you found it useful
Blog - www.angeldeeps.blogspot.com
Community - www.dotnetspider.com/sites/303/-TECHIE-QUESTIONNAIRE.aspx
|
| Author: Roopesh Babu Valluru 01 Dec 2008 | Member Level: Gold | Rating: Points: 3 |
Hi Friend..
This wil help u i think...
select top 10 * from tablename where primarykeycolumn not in (select top 5 primarykeycolumn from tablename)
All The Best..
|
| Author: sonali chougule 01 Dec 2008 | Member Level: Silver | Rating: Points: 1 |
select top 15 col1 from table1
where
col1 not in(
select top 5 col1 from table1)
|