how to find the second highest salary from emp table?
- 211 Answers
- 321937 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
How many joins in sql?
What are the basic techniques of indexing?
What is difference between left and right outer join?
What is the use of prepared statement?
Mention what are different methods to trace the pl/sql code?
How does one use sql*loader to load images, sound clips and documents? : aql loader
How do I run a pl sql program?
What are the different operators available in sql?
Define tables and fields in a database
Explain ttitle and btitle.
What are database links used for?
What does count (*) mean?
What is pl/sql language case sensitive?
When you have to use a default "rollback to" savepoint of plvlog?
What are records give examples?
