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
- 18417 Views
- Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / x.cannon
SELECT * FROM
(
SELECT NTILE(2) AS div, * FROM
(
SELECT TOP(20) FROM <table_name>
) AS tmp
) AS tmp WHERE div = 2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you understand by a view? What does the with check option clause for a view do?
What is the architecture of ms sql reporting service?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What are the diifferences between the ms sql server vs mysql?
What is the difference between a stored procedure and a user defined function?
Explain datetime2 data type in sal server 2008?
what does the automatic recovery do? : Sql server administration
How to use clusters?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What are indexes in sql?
Name few of the dcl commands in sql?
How would you choose between a clustered and a non-clustered index?
Why union all is faster than union?
What is a group function explain with an example?
Explain how dts is used to extract, transform and consolidate data?
