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
- 18043 Views
- Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / shilpa
with temp
as
( select row_number() over(order by city) rowid, * from
employee)
select * from temp
where rowid >= 10
and rowid <= 20
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What does the not null constraint do?
What happens if the update subquery returns multiple rows in ms sql server?
What is named query? : sql server analysis services, ssas
what are the different stages of Report Processing?
When columns are added to existing tables, what do they initially contain?
How to replace given values with null using nullif()?
What is sql service broker?
What is difference between join and natural join?
What happens if an integer is too big for int date type?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
How to modify an existing stored procedure in ms sql server?
What are the types of table?
What is the recommended total size of your memory optimized tables?
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 are window functions in sql server?
