Find 2nd Highest salery in emp table
Select* from emp where &n=
select * count from emp where (salery >=emp.salery)
Enter n value 2
These query is correct or not. Tell me any other methods.
- 6 Answers
- 7189 Views
- I also Faced
- E-Mail Answers
Answer Posted / asimananda
SELECT MAX(SAL) FROM EMP WHERE SAL < ( SELECT MAX(SAL) FROM
EMP )
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Relational calculus is what type of language?
What is stored procedures?
How global temporary tables are represented and its scope?
Can sql servers linked to other servers?
How to use transact-sql statements to access the database engine?
What is merge replication?
Explain the use of containers in ssis?
what information is maintained within the msdb database? : Sql server administration
What can be used instead of trigger?
What is normalization? What number of normalization shapes are there?
In which sql server version report builder introduced?
What stored by the master?
What is create statement?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
what is create database syntax? : Sql server database administration
