Answer Posted / m gangadhar
select * from (select a.* from employees a order by
a.salary desc) where rownum <= 5
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is an index? How can an index be declared in mysql?
What are Heap tables?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
Is pdo more secure than mysqli?
What is mysql and how it works?
What is procedures in mysql?
Is mysql still popular?
What are the three types of queries?
What are features of mysql?
How can you count the total number of records of any table?
How to get nth highest salary from table in a mysql?
How can I create a database in mysql?
Can mysql and mariadb coexist?
What is the default port for MySQL Server?