select max(sal) from emp;

find out first highest salary?

Question Posted / la

10 Answers
16381 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

What is background process in Oracle?

1101

What is ASM (Automatic Storage Management) in Oracle?

1196

Please explain oracle left join with an example?

1045

What language does oracle use?

1098

What is the sql query to concatenate column values from multiple rows in oracle?

1056

How many types of table in Oracle?

1120

How to initialize variables with default values?

1240

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5550

How to declare a local variable?

1112

What is the dynamic sql in oracle?

1071

How to count duplicated values in a column in oracle?

1039

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2008

How to find the duplicate rows count from employees table in oracle?

1090

How many types of cluster table in Oracle?

1034

Why is oracle used?

938