Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368928 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 / jayshree
select max(sal) from table_name where sal not in (select
max(sal) from table_name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is numeric function sql?
What is exception? What are the types of exceptions?
What is cursor status?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Why do we need a foreign key?
What is the difference between sum and count in sql?
What happens when a trigger is associated to a view?
How many postgresql users are there, worldwide?
What is pl sql commands?
What is the difference between unique and primary key constraints?
Which certification is best for sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is view explain with example?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Are null values same as that of zero or a blank space?
