select max(sal) from emp;

find out first highest salary?

Question Posted / la

10 Answers
16109 Views
Verinon Technology Solutions, I also Faced
E-Mail Answers

Answer Posted / la

select max(sal) from emp;

Is This Answer Correct ?

15 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differentiate between function and procedure in oracle.

1032

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2067

How to rename an index in oracle?

1079

Why cursor variables are easier to use than cursors?

1037

Difference between inner join vs where ?

996

How to use fetch statement in a loop?

991

What is a server parameter file in oracle?

1019

What is an Oracle index?

1617

How to estimate disk space needed for an export job?

1004

Explain the use of rows option in exp command.

1044

what is the difference between functional dependecy and multilevel dependency?

2429

What is a cursor variable?

1063

How can we force the database to use the user specified rollback segment?

1091

What is Redo Log Buffer in Oracle?

1152

What is the difference between sharding and replication?

980