suppose we have a table in which 200 rows. i want to find
101 row ? what the query....
and how we find 4th and 5th highest salary and 1 to 10
highest salary
- 7 Answers
- 11505 Views
- I also Faced
- E-Mail Answers
Answer Posted / vishnu
if you have table temp_test1
you fire
select * from temp_test1
now you want 101 rows
basic thing here is records are sorted by rowid as per
insertion
for 101 th row
select * from temp_test1 where rowid in(
(select max(rowidtochar(rowid)) from temp_test1 where
rownum<102))
this is asked in tech mahindra
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can we use joins in subquery?
What is the usage of the distinct keyword?
Which function is used to return remainder in a division operator in sql?
What is field delimiter?
What are all the ddl commands?
What is auto increment in sql?
What is the syntax and use of the coalesce function?
What is difference between cursor and trigger?
How do I view a sql database?
Sql technical questions
How can I get the number of records affected by a stored procedure?
Is sqlite free?
What operators deal with null?
Why trigger is used in sql?
How do you run a query?
