Answer Posted / kishore
select * from (
select sal,rownum as num from (select sal from
emp order by sal desc))
where num <=3;
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
what are the join types in tsql? : Transact sql
What are the different parts of a package?
How many sql statements are used? Define them.
Difference between truncate, delete and drop commands?
How can we debug in PL/SQL?
Differentiate between % rowtype and type record.
What are sql functions? Describe the different types of sql functions?
What is an escape character in sql?
Can function return multiple values in sql?
how to do backup entire database? : Transact sql
what is blob? : Sql dba
Does mysql support pl sql?
How do I sort a table in sql?
What is the current version of postgresql?
How does a self join work?