Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373002 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 / radha sri seshu.kolla
select max(sal) from emp where level=2 connect by prior
sal>sal group by level;
| Is This Answer Correct ? | 17 Yes | 22 No |
Post New Answer View All Answers
Give the order of sql select?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
what are the advantages of using stored procedures? : Sql dba
What are different types of queries in sql?
What are the key differences between SQL and PL SQL?
How to read/write files from pl/sql?
how is myisam table stored? : Sql dba
How to get unique records from a table?
What is a parameter query?
what is the difference between char_length and length? : Sql dba
how can you see all indexes defined for a table? : Sql dba
How to make a copy values from one column to another in sql?
Are stored procedures compiled?
Show the two pl/sql cursor exceptions.
How do you run a query?
