Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pradeep
select * from emp where sal in(select min(sal) from (select
sal from emp order by sal
desc) where rownum <= 3);
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What does sql stand for?
What is database sql?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How many scalar data types are supported in pl/sql?
What is input buffer in sql*plus?
How do you use join?
What is oracle pl sql developer?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is the difference between partition and index?
What is the difference between a subquery and a join?
Can we use delete in merge statement?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Can we call a function containing dml statements in a select query?
What is multiple columns?
Explain mutating table error.
