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 do I view a sql database?
What is coalesce sql?
How delete all records from table in sql?
How exception is different from error?
Why do we use cursors?
Does postgresql run on the cloud?
what are numeric data types? : Sql dba
Explain two easy sql optimizations.
How to execute a stored procedure?
How many types of triggers are there in pl sql?
How do you modify a column in sql?
What is the command used to fetch the first 5 characters of a string?
Mention what is the plv (pl/vision) package offers?
Which are sql * plus commands?
What is the max nvarchar size?