Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373262 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / adithya
select min(sal) from (select distict sal from emp where
rownum<3 order by sal desc)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Can you have a foreign key without a primary key?
How can a function retun more than one value in oracle with proper example?
What are all the ddl commands?
Does varchar need length?
What is pls_integer in pl sql?
What is an index in sql with example?
Why indexing is needed?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What are the types of records?
What is an exception in pl/sql?
What is pl sql and why it is used for?
Explain the the update statement in sql?
How many types of sql are there?
What is full join in sql?
