Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 50765 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / mohammad murtuza ali
select * from emp as(empname,empsal,empdesc) where rownum<6
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
State few characteristics of pl/sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is sql profiling in oracle?
What is a join query?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is the difference between drop and truncate commands?
How exception is different from error?
Can sql function call stored procedure?
Can cursors be part of a trigger body?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
How do I audit the sql sent to the server?
How would you pass hints to the sql processor?
how many tables will create when we create table, what are they? : Sql dba
What is data types in sql?
