Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
- 10 Answers
- 18063 Views
- Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / newbie
SELECT E.* FROM
(SELECT ROW_NUMBER() OVER (ORDER BY EmpID) AS RowCounts,
Salary FROM Emp) AS E
WHERE E.RowCounts BETWEEN 10 AND 20
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How do I open port 1433?
What are the different subsets of sql?
What is simple indexing method?
What is ms sql server triggers?
What is faster join or union?
Explain what you mean by 3 tier architecture.
Explain sql delete command?
What is table-valued sub query?
What is clustered index
What are the components of dbms?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is the purpose of object explorer and its features? : sql server management studio
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is a result set object returned by odbc_exec()?
What is the use of commit?
