Answer Posted / lince
select T.* from(
select row_number() over (order by salary desc)as rno,salary from table )T
where T.rno=100
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is sql query limit?
How do I remove all records from a table?
What is application trigger?
What are the rules to be applied to nulls whilst doing comparisons?
What is the difference between cluster and non-cluster index?
What are all the different normalization?
How to call a javascript function from pl sql?
What is an inner join sql?
Can you do multiple joins in sql?
What is the use of count (*) in sql?
What is sqlerrd?
What are synonyms in sql?
Can we insert in sql function?
What is an invalid partition table?
