Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361207 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 / arjunraj
aa means table-alias name
bb means table-alisa name
select * from emp aa where 2=(select count(distinct empsalary) from emp bb where aa.empsalary<=bb.empsalary)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql procedures and functions?
What are reports usually used for?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is the difference between sql and mysql?
what is a constraint? : Sql dba
How much does sql cost?
What is offset in sql query?
What is a relationship and what are they?
How do I find duplicates in two columns?
Can we commit in trigger?
What is java sql driver?
When you have to use a default "rollback to" savepoint of plvlog?
how to get help information from the server? : Sql dba
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Explain what is a view?
