Write a query to find second highest salary of an employee.
Answer Posted / akilis.org@hotmail.com
Let us assume that
Table Name:salary
Coloumn Name:maxsal(int)
select * from salary order by maxsal desc limit 1,1;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How many sql commands are there?
What is sqlcommand?
What is a memo field?
What are pl/sql cursor exceptions?
explain the advantages and disadvantages of stored procedure? : Sql dba
Can we create clustered index without primary key?
Why we use stored procedure instead of query?
What is sql procedures and functions?
What is insert command in sql?
How do you change a value in sql?
What are sql data types?
What is a natural join sql?
explain about mysql and its features. : Sql dba
How exception is different from error?
What is the non-clustered index in sql?