Interested to Buy Any Domain ? << Click Here >> for more details...
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
Please Help Members By Posting Answers For Below Questions
What is auto increment in sql?
What is execute immediate?
What are types of joins?
Is primary key a clustered index?
How to know the last executed procedure?
How to run pl/sql statements in sql*plus?
how to check myisam tables for errors? : Sql dba
When to use inner join and left join?
Can we perform dml in function?
How many subqueries can be nested in a statement?
what are date and time intervals? : Sql dba
How does sql store data?
explain what is mysql? : Sql dba
How do you sort in sql?
What is a table partition?
