Interested to Buy Any Domain ? << Click Here >> for more details...
A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 27621 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bhargav
SELECT * FROM
(
SELECT Row_Number() OVER (ORDER BY emp_id, emp_name) as
emp_name
FROM employees
) as a
where rowid >100 AND rowid<121
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Where is all the data on the internet stored?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What are properties of the transaction?
What is database white box testing and black box testing?
what is self-join? : Sql dba
What is the use of procedures?
How to find 3rd highest salary of an employee from the employee table in sql?
What is 19 null in sql?
Explain the working of primary key?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
Are left and right joins the same?
What is sqlcommand?
How to select all records from the table?
What is full form of rtm?
Why do we use view in sql?
