Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367668 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 / satish kumar
Select Top1 salary
from(select Distinct Top2 salary from employee order by salary DESC) a order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is primary key in db?
Write a sql query to find the names of employees that begin with ‘a’?
Can we create a trigger on view?
Can we delete column in sql?
How is pl sql different from sql?
What are sql indexes?
how to create a test table in your mysql server? : Sql dba
how to use case expression? : Sql dba
Describe types of sql statements?
How to use transactions efficiently : transact sql
How do we accept inputs from user during runtime?
What is prepared statement in sql?
How can we avoid duplicating records in a query?
how to convert character strings to numeric values? : Sql dba
Which table is left in join?
