how to find the second highest salary from emp table?
Answer Posted / chandu
select max(sal)from table name where sal<(select max sal
from table name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is row? : Sql dba
How can we find duplicate records in a table?
What is the difference between microsoft access and sql?
What is tuple in sql?
What are sql constraints?
what is text? : Sql dba
What steps server process has to take to execute an update statement?
what is meant by nl2br()? : Sql dba
What is auto increment feature in sql?
What do you mean by table in sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
what are the authentication modes in sql server? : Sql dba
How do I count duplicates in sql?
How to use boolean type in select statement?
Is it possible to update views?