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 oracle and what are its different editions?

1038

What is a package in oracle?

1058

how the indexes are stored in the Oracle Database?

2234

Is a rollback possible to any savepoint?

1030

What is oracle host variable?

1010

Give the constructs of a package, function or a procedure.

1005

What is a table index?

1034

Can we write insert statement in function in oracle?

1051

Whether any commands are used for months calculation? If so, what are they?

1057

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5368

What is a data lock in oracle?

1056

How do I manually uninstall oracle client?

1043

How to define and use table alias names in oracle?

900

Explain an exception and its types?

1036

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2231