| 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://codepronet.blogspot.com/
|
| 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
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|
| 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)
|