select max(sal) from emp <<<assuming emp is the table name and

find out first highest salary?

Question Posted / ela tiku

Answer Posted / ela tiku

select max(sal) from emp

<<<assuming emp is the table name and sal is the column
name>>>

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to bring a tablespace online?

999

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2056

How to find out what oracle odbc drivers are installed?

979

What is using clause and give example?

999

How to loop through a cursor variable?

1013

How to return top 5 rows in oracle?

991

What is the difference between 10g OEM and 11g OEM?

917

What to do if the startbd.bat failed to start the xe instance?

1017

What happens if the update subquery returns multiple rows?

1046

What is the disadvantage of User defind function?

2239

How to drop an index in oracle?

1022

Explain parameter file in oracle.

974

How to rollback the current transaction in oracle?

987

Explain oracle instance.

1107

how to do daily transactions with out sql* loader control file regesterd in apps?

1629