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 do I know if oracle is installed on windows?

931

What privilege is needed for a user to create views in oracle?

1046

What happens to indexes if you drop a table?

1169

What is MTTR advisor in Oracle?

1090

How to convert dates to characters in oracle?

1041

What is the difference between postgresql and oracle?

1048

What are the attributes that are found in a cursor?

1075

How to connect to oracle using service name instead of sid?

1025

What is a lookup table in oracle?

973

Explain a synonym?

1028

What privilege is needed for a user to create indexes in oracle?

1028

How to rename an index?

1071

How to load data through external tables?

1135

What suggestions do you have to reduce the network traffic?

961

How to delete an existing row from a table in oracle?

1072