How to read 2nd highest sal from EMP table?
Answer Posted / sasikala
select max(salary) from emp where salary<(select max(salary) from emp);
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
application server is slow what may be the problem
Differentiate between a primary key and a unique key.
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is isnull() operator?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is the difference between Triggers and Stored Procedure?
What are the different authentication modes in sql server? How can it be changed?
What are system databases into sql server (2005/2008) : sql server database administration
How do users use Report Builder with SQL Server data sources?
Explain transaction server auto commit?
How to bind a view to the schema of the underlying tables?
What are number line correlation administrators will use while working with a subquery?
Why use triggers?
What is not null constraint?
How to get a list all databases on the sql server?