Select All Rows Except First Two Rows

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Select All Rows Except First Two Rows

Author

Topic

sree432
Starting Member

7 Posts

Posted - 2004-11-18 : 03:14:15

Table Name : Emp
Totals Cols Present : 5
EmpId EmpName
1 ST
2 BL
3 SW
4 BS
5 SR

I wanted to select all rows except first two rows(ie , 1 and 2)
Out Put Should Be Like This
EmpId EmpName
3 SW
4 BS
5 SR

Thanking You.

Sreedhar Reddy

Kristen
Test

22859 Posts

Posted - 2004-11-18 : 03:16:37

SELECT EmpId, EmpName
FROM Emp
WHERE EmpId NOT IN (SELECT TOP 2 EmpId FROM Emp ORDER BY EmpId)
ORDER BY EmpId

Kristen