select ename, salary from emp where salary=(select max (salary) from emp)

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

Question Posted / selvaraj v , anna university c

select ename, salary from emp where salary=(select max
(salary) from emp) order by emp_no;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is single byte over head in oracle..?

2342

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3010

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1161

What is an example of translating a date into julian format?

1042

What is the advantage of nosql?

996

What is the use of index in hive?

964

Is primary key a clustered index?

914

What is the use of sqldataadapter?

911

What is t sql in sql server?

1003

Is postgresql a nosql database?

1079

What is asqueryable?

905

How to return an array from java to pl/sql?

1063

What is error ora-01000: maximum open cursors exceeded

1065

How to fetch alternate records from a table?

1160

List and explain the different types of join clauses supported in ansi-standard sql?

1301