Answer Posted / lince
select sal from
(
select row_number() over (order by sal desc) as rno,sal
from Emp
)T
where T.rno=100
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is a call statement? Explain with an example.
Why truncate is used in sql?
Can we call a function containing dml statements in a select query?
what is foreign key? : Sql dba
Explain what is dbms?
How to use sql statements in pl/sql?
What is a sql schema used for?
What is foreign key sql?
What is difference between my sql and sql?
What is localdb mssqllocaldb?
How can you know that statistics should be updated?
What view means?
What are all the different normalizations?
What is sql constant?
What is sql performance tuning?