Answer Posted / satya
SELECT salary FROM emp order by ordering DESC limit 2,1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
What is tee command in mysql?
How do you rename a procedure in mysql?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
What is general log in mysql?
How to do login in mysql with unix shell.
How do you create a schema?
What is data node in mysql cluster?
What is procedural api?
How to delete the repeated records from a table?
What are the steps involved in query processing?
What is a crosstab query?
What is a user defined variable?
What is the use of mysqli_num_rows?