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

What is the difference between view and materialized view in Oracle?

1207

How to work with data objects interactively?

1043

What are the different windows events activated at runtime ?

2945

What is the maximum limit on the number of columns in a table?

1152

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1096

Is there any function in oracle similar like group_concat of mysql?

1106

How to connect the oracle server as sysdba?

1131

What is recycle bin in Oracle?

1198

How to drop a stored procedure in oracle?

1105

IS it possible to built the oracle database without setting the kernal parameters?

2395

Can a parameter be passed to a cursor?

1180

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1095

How to shutdown your 10g xe server from command line?

1152

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2398

What are internal user account in oracle?

1055