Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12911 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 can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is using in sql?
What are different methods to trace the pl/sql code?
What are the different dcl commands in sql?
describe mysql connection using mysql binary. : Sql dba
Can primary key be changed?
what are enums used for in mysql? : Sql dba
Can there be 2 primary keys in a table?
How do you update a table in sql?
What is raid? How does it help storage of databases?
Is like operator in sql case sensitive?
Define overloaded procedure?
How much does sql cost?
What is the purpose of a secondary key?
What is sqlservr exe?
