Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367643 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 / manvar prajesh
select top 1 name,salary from emp where salary<(select
max(salary) from emp)order by salary desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to return an array from java to pl/sql?
Does truncate free space?
What is an inner join sql?
What is consistency?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is t sql in sql server?
What is the non-clustered index in sql?
What are stuff and replace function?
What does varchar include?
What is the difference between count 1 and count (*) in a sql query?
How to read xml file in oracle pl sql?
What is an exception in PL/SQL? What are the two types of exceptions?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is an index in sql with example?
Can we join same table in sql?
