From an Employee table, how will you display the record
which has a maximum salary?
Answers were Sorted based on User's Feedback
Answer / hari
select max(sal) from employee;
or
select * from employee where sal in(select max(sal) from employee);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venubabu addagada
SELECT DISTINCT
( e.emp_salary )
FROM
employee e
WHERE
&n = (
SELECT
COUNT(DISTINCT(e1.emp_salary) )
FROM
employee e1
WHERE
e1.emp_salary > e.emp_salary
);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sudeep mishra
select *
from employee
where salary = max sal
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
Answer / jayshree
SELECT LAST_NAME,MAX(SALARY)
FROM EMPLOYEES
GROUP_BY SALARY;
Is This Answer Correct ? | 2 Yes | 8 No |
What is multiple columns?
Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause
What are sql functions? Describe the different types of sql functions?
What is INSTEAD OF trigger ?
What is the difference between the conventional and direct path loads? : aql loader
Write an sql query to select all records from the table?
Is join same as left join?
Is pl sql different from sql?
What is sql*plus?
How can you fetch first 5 characters of the string?
What is a Procedure ?
What is difference between sql and mysql?