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
What is example of database?
What are the different types of constraints?
What is multiple partition?
What is the location of pre_defined_functions.
What do you mean by table in sql?
Why do we go for stored procedures?
what is the functionality of the function htmlentities? : Sql dba
What are database links used for?
What is the difference between clustered and non-clustered index in sql?
What do you think about pl/sql?
Can we insert delete data in view?
what are the properties and different types of sub-queries? : Sql dba
Is sql better than access?
what is meant by urlencode and urldocode? : Sql dba
How do I view stored procedures?