Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361254 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 / ruma
select *from emp order by sal desc limit 1,1
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Is left join faster than inner join?
How you improve the performance of sql*loader? : aql loader
what is union? : Sql dba
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Why use triggers in sql?
Which is better join or inner query?
What are analytical functions in sql?
How do you sort in sql?
Why is sql important?
What is difference between stored function and application function?
What can I use instead of union in sql?
How do I filter in sql profiler?
How to raise user-defined exception with custom sqlerrm ?
How can you load multi line records? : aql loader
