SELECT * FROM employees WHERE salary = (SELECT MAX(salary) FROM employees)

From an Employee table, how will you display the record
which has a maximum salary?

Question Posted / suresh babu

Answer Posted / suresh babu

SELECT * FROM employees WHERE salary = (SELECT MAX(salary)
FROM employees);

This query will return the employee details,who getting
maximum salary.

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1020

What is cartesian join in sql?

1026

What is the usage of distinct keyword?

1017

how to escape special characters in sql statements? : Sql dba

962

Explain how to use transactions efficiently : transact sql

920

What is recursive join in sql?

945

What does truncate mean in sql?

961

What is rowtype?

953

Can primary key be changed?

861

how many tables will create when we create table, what are they? : Sql dba

1018

how can we optimize or increase the speed of a mysql select query? : Sql dba

879

What is difference between table and view?

972

Can you upgrade sql express to full sql?

994

Define a temp table?

961

What are conditional predicates?

986