Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373287 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
What is normalisation and its types?
What are variables in pl sql?
Advantages and disadvantages of stored procedure?
How do I find duplicates in two columns?
How many types of triggers are there in pl sql?
Why use subqueries instead of joins?
How can get second highest salary in sql?
What is sequence in sql?
How to avoid duplicate records in a query?
Can we update views in sql?
What is where clause in sql?
What is the difference between execution of triggers and stored procedures?
What does count (*) mean?
What is db journal file?
Why stored procedure is faster than query?
