Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373093 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 / sabari
select max(salary ) from emp where salary<(select max
(salary)from emp )
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is sql indexing?
Where is all the data on the internet stored?
What is benefit of creating memory optimized table?
What is right join in sql?
What is oracle sql called?
How do I view tables in mysql?
How do I sort a table in 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
what are all types of user defined functions? : Sql dba
How to select unique records from a table?
Is time a data type in sql?
What makes a good primary key?
What is scope of pl sql developer in future?
What is the difference between stored procedure and view?
What is sequence in sql?
