Answer Posted / priya
select top 1 salary from ( select top 3 salary from ( select
distinct salary from employee order by desc ) order by asc);
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How to run a sql statement?
How to get a list of columns in an existing table?
Why phpmyadmin is used for mysql?
Explain about reporting services of MYSQL?
How to create trigger in mysql workbench?
What is mysql good for?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
Is mysql written in c?
What are triggers mysql?
Can you tell what are various ways to create an index?
How can we find out which auto increment was assigned on Last insert?
What is a text delimiter?
Why do we use preparedstatement?
How do stored procedures work?
Which is faster mongodb or mysql?