Answer Posted / xyz
select rownum, salary from (select salary from employees order by salary desc)
where romnum<=100
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What are local and global Indexes and where they are useful.
How do you go back in sql?
What are the steps for performance tuning.
How can we avoid duplicating records in a query?
How does an execution block start and end in pl sql?
Is sql better than access?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Can we join more than 2 tables in sql?
How many clustered indexes can you have?
What are the set operators in sql?
Are subqueries faster than joins?
What is the use of primary key?
What are string functions in sql?
What is the difference between the conventional and direct path loads? : aql loader
How do I add a database to sql?