how to find out largest value in a table

Question Posted / shabbirmca

Answers were Sorted based on User's Feedback

how to find out largest value in a table..

Answer / shafeeq

Select max(salary) from emp;

Is This Answer Correct ?

6 Yes

1 No

how to find out largest value in a table..

Answer / pradeep kolakala

Select max(sal) from ithpharma.UserRole where version
not in (select max(sal) from ithpharma.UserRole)

Is This Answer Correct ?

1 Yes

3 No

More Oracle General Interview Questions

find out the second highest salary?

Point out the difference between user tables and data dictionary?

is database gud carrier option??

how to tune oracle sql queries pls tell me step by step. urgent pls

What are the Characteristics of Data Files ?

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

What is a deadlock ? Explain .

How to use values from other tables in update statements using oracle?

Can we create more than one index on particular column?

How to define a cusotmer as a supplier in ORACLE R12

what is difference between table and view? where to use views? thanks in advance!

Can Multiple instances be run on Single Machine???

For more Oracle General Interview Questions Click Here