how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

What is the use of count function in mysql?

0 Answers  


What can I do with mysql?

0 Answers  


How do you rename a table?

0 Answers  


HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

0 Answers  


How many services is running in sql server?

3 Answers   ACC, V2 Solutions,






How do you create a schema?

0 Answers  


How do I restore a mysql database dump file in linux?

0 Answers  


How can we get the number of rows affected by query?

0 Answers  


Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  


How to see the database architecture in MySQL??

3 Answers  


How to concatenate two character strings?

0 Answers  


Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

5 Answers   Amdocs, MediaSoft,


Categories