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

Point out the difference between user tables and data dictionary?

967

Explain the use of constraints option in exp command.

1028

How to drop an index in oracle?

1052

if you ctreate table identity

2353

Explain what are the uses of rollback segment?

992

What are the parameters that we can pass through a stored procedure?

1047

How to select some rows from a table in oracle?

1055

What is sequence?

1060

What is a trigger oracle?

1072

How to insert a new row into a table in oracle?

1138

What are the restrictions in a oracle read only transaction?

1008

How different is ms access and oracle?

1020

What is SQL access advisor in Oracle?

1178

What is pragma autonomous transaction in oracle?

1042

How many types of segments in Oracle?

1054