how to get second highest salary in SQL(as/4000
Answer Posted / selvaraj v , anna univ coe
SELECT * FROM Employee e
WHERE 2=(SELECT COUNT(DISTINCT Salary) FROM Employee x
WHERE x.Salary >= e.Salary);
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can triggers stop a dml statement from executing on a table?
how to convert numeric values to character strings? : Sql dba
What is difference between pl and sql?
what is top in tsql? : Transact sql
what is the difference between where clause and having clause? : Sql dba
how to convert character strings to numeric values? : Sql dba
What is the most important ddl statements in sql are?
What does stand for in sql?
What do you think about pl/sql?
Can we create index on primary key?
Why do we create views in sql?
what is error ora-03113: end-of-file on communication channel?
What is exit statement?
Are sql connections encrypted?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.