Please help me out .
I need to retrieve the records from 11th row onwards using select query. Please help me out . Its urgent. Thanks
This is what I would do. Imagine you have table "Employee" with this two fields FirstName, LastName then you can do this.
SELECT FirstName, LastName, RowNumber FROM( SELECT Emp.FirstName, Emp.LastName, (SELECT COUNT(*) FROM Employee AS Emp2 WHERE (Emp2.LastName < Emp.LastName)) AS RowNumber FROM Employee AS Emp) AS derivedTable WHERE RowNumber >= 11 ORDER BY RowNumber
select * from (select FirstName, LastName, ROW_NUMBER() over (order by LastName,FirstName) as 'Row' ) a where Row >=11
Pretty much the same thing as jbisono's query.
The problem with your statement adam is that ROW_NUMBER() is not supported by SQL 2000, but besides that I like your statement better :-) ....
Missed that requirement, you are right.
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.