Write a query to find second highest salary of an employee.
Answer Posted / cooldude
select max(sal) from Emp where sal < (select max(sal) from
Emp)
Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
How do I trace sql profiler?
What is the most important ddl statements in sql are?
Why do we create views in sql?
Should I use mbr or gpt?
What do you think about pl/sql?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Mention what plvcmt and plvrb does in pl/sql?
Advantages and disadvantages of stored procedure?
Differentiate pl/sql and sql?
Name the different types of indexes in sql and define them.
How many postgresql users are there, worldwide?
What is character functions?
Which is better varchar or nvarchar?
what is 'mysqlshow'? : Sql dba
What port does sql server use?