Answer Posted / saiz
select min(salary)
from emp
where salary in ( select top 2 salary
from emp
order by salary desc);
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can we alter stored procedure?
What is sqlservr exe?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is a sql instance vs database?
What are the various levels of constraints?
How do I run a sql trace?
what are the t string functions available in tsql? : Transact sql
Differentiate between pl/sql and sql?
How to write a query to show the details of a student from students table whose
Is it possible to pass parameters to triggers?
What is synonyms?
Are stored procedures faster than queries?
Can I join the same table twice?
Differentiate between syntax and runtime errors.
How to call shell script from pl sql procedure?