Interested to Buy Any Domain ? << Click Here >> for more details...
Find out the 3rd highest salary?
- 51 Answers
- 74211 Views
- BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
- E-Mail Answers
Answer Posted / vishal beri
Select ename from emp e where 2=(select count(distinct(Sal))
from emp where sal>e.sal)
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Why do we create stored procedures & functions in pl/sql and how are they different?
Why stored procedure is faster than query?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
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 left inner join in sql?
How do you optimize a stored procedure query?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
How do you modify a column in sql?
define data blocks ? : Sql dba
How to assign sql query results to pl sql variables?
What is identity column in sql server?
How do you select unique values in sql?
Will truncate release space?
What is difference between joins and union?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
