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
- 11528 Views
- I also Faced
- E-Mail Answers
Answer Posted / hemant
select * from emp where (rowid,0) in
(select rowid,mod(rownum,101) from emp)
and rownum=1
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
how to create a new table in mysql? : Sql dba
How do I order by ascending in sql?
What is the difference between join and natural join?
What are the advantages of pl sql over sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
give the syntax of grant and revoke commands? : Sql dba
What is meant by cursor in sql?
How can we store rows in PL/SQL using array?
how to shutdown mysql server? : Sql dba
Is sql a case sensitive language?
What are local and global Indexes and where they are useful.
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Why do we create views in sql?
What is the difference between left and left outer join?
What does sql stand for?
