Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 372955 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 clustered index in sql?
What are sql functions? Describe the different types of sql functions?
What is keys and its types?
Can we have two clustered index on a table?
How do I create an index in word?
What is primary key sql?
Why is sql important?
What is the difference between functions, procedures, and packages in pl/sql?
how to include comments in sql statements? : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
What are dml commands?
What is graph sql?
what are all types of user defined functions? : Sql dba
what is the different between now() and current_date()? : Sql dba
What is function and procedure in pl sql?
