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
- 12379 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
Whis is not false in primary key?
what is a cursor? : Sql dba
differentiate between float and double. : Sql dba
Explain lock escalation? : Transact sql
What is nested table in pl sql?
Is nosql relational?
How do I start sql from command line?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
How do you rename a table in sql?
What are the three forms of normalization?
What is meaning of <> in sql?
Is sql a programming?
How many triggers can be applied to a table?
Name the operator which is used in the query for pattern matching?
what are ddl statements in mysql? : Sql dba
