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 are sql*plus environment variables?
what is an index? : Sql dba
What is sql partition function?
What are synonyms in sql?
How do I view a view in sql?
Define implicit and explicit cursors.
What are tables and fields?
Is truncate ddl or dml?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
How do you update a sql procedure?
What is rank function in sql?
what are properties of a transaction? : Sql dba
how does a local variable is defined using t-sql? : Transact sql
Which certification is best for sql?
Which are the different character-manipulation functions in sql?