Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368422 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 / pankaj raj patel
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What is exception? What are the types of exceptions?
what is index? : Sql dba
What are aggregate functions in sql?
What is on delete set null?
What is sql partition function?
How many sql are there?
Where is pl sql used?
What pl/sql package consists of?
What is the purpose of the partition table?
What is time based sql injection?
How do I run a sql trace?
What does where 1 1 mean in sql?
Why cross join is used?
how do you tune the slow running queries in oracle db , explain the methodology
What is int identity in sql?
