From an Employee table, how will you display the record
which has a maximum salary?
Answer Posted / 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 |
Post New Answer View All Answers
Which is better stored procedure or query?
What is dynamic query?
What is difference between rank () row_number () and dense_rank () in sql?
Explain architecture of sql server notification services?
What is group function in sql?
Why truncate is faster than delete?
What is set transaction?
Which is faster count (*) or count 1?
How to install oracle sql developer?
What is blind sql injection?
How do you concatenate in sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
How to connect a sql*plus session to an oracle server?
Is sql better than excel?
What is indexing oracle sql?