how to get second highest salary in SQL(as/4000
Answer Posted / premchand
select max(sal) from employ where sal < select max(sal)
from employ
| Is This Answer Correct ? | 34 Yes | 12 No |
Post New Answer View All Answers
What trigger means?
How do you use collections in procedure to return the resultset?
What does subquery mean in sql?
which operator is used in query for pattern matching? : Sql dba
Can a table contain multiple foreign key’s?
How long it takes to learn pl sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is the difference between Union and Union all. Which is faster.
Why are aggregate functions called so?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What does sql stand for?
What is varchar data type in sql?
Define concurrency control. : Transact sql
What is the use of sqldataadapter?
What is the basic structure of an sql?