Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373187 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 / nevin
select min(salary) from (select top 2 sal from table_name order by sal desc)salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is t sql in sql server?
Explain the savepoint statement.
what are the performance and scalability characteristics of mysql? : Sql dba
How do you identify a primary key?
What are two statement types in sql?
Is stored procedure faster than query?
Are pl sql variables case sensitive?
What sql does db2 use?
What is the difference between the sql*loader and import utilities? : aql loader
what is a foreign key ? : Sql dba
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
How do you exit in sql?
What is self-join and what is the requirement of self-join?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is sql dialect?
