Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367655 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 / atheeq
select distinct emp_sal from emp where 1 order by emp_sal
desc limit 1,1
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is gpt format?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Does sql backup shrink transaction log?
Explain the uses of database trigger.
How do I access sql anywhere database?
Explain the difference between drop and truncate commands in sql?
What is the difference between unique and primary key constraints?
What is sql deadlock?
How to avoid duplicate records in a query?
how can we find the number of rows in a table using mysql? : Sql dba
Explain ttitle and btitle.
How to Execute a Package in PL/SQL.?
Why do we need a foreign key?
when is the use of update_statistics command? : Sql dba
What is java sql driver?
