Interested to Buy Any Domain ? << Click Here >> for more details...
Given an employee table, how would you find out the second
highest salary?
- 9 Answers
- 14828 Views
- I also Faced
- E-Mail Answers
Answer Posted / vivek mohan singh
select salary from tablename order by salary desc limit 1,1;
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How long can an error message be in raiseerror function?
How to generate OIDS
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What are the three types of database design?
State the acid rules?
What is the database development process?
How can I detect whether a given connection is blocked?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
How would you design a database for an online site, which would average a million hits a day?
How to customize error conditions.
What is a database development?
What is dbms and its application?
What are the types of database model?
