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 are commit, rollback, and savepoint?
Why we use sql profiler?
how can we repair a mysql table? : Sql dba
What do you understand by exception handling in pl/sql?
Do ddl statements need commit?
define sql update statement ? : Sql dba
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Which are the different character-manipulation functions in sql?
Why is sql important?
How do you exit in sql?
Can we rollback delete command?
Does oracle roll back the transaction on an error?
What is sqlca in powerbuilder?
what is the difference difference between procedure and packages
Why stored procedure is better than query?
