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
how to get @@error and @@rowcount at the same time? : Sql dba
What is sorting in sql?
How can you tell the difference between an index and a view?
What is synonyms?
What is meant by <> in sql?
What is the use of stored procedures?
Is sql workbench free?
how to calculate the difference between two dates? : Sql dba
Show the two pl/sql cursor exceptions.
What is Materialized View? In What Scenario we Use Materialized View?
Is sql sequential or random?
What is the maximum number of triggers, you can apply on a single table?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
what is the difference between myisam static and myisam dynamic? : Sql dba
What is faster join or subquery?