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

What are different Oracle database objects?

How to work with data objects interactively?

8. Display the client name and order date for all orders using the natural join keywords.

What is key preserved table?

Select the Nth lowest value from a table?

Â How to use an oracle sequence generator in a mapping?

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

What to do if dba lost the system password?

What privilege is needed for a user to connect to oracle server?

24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.

What privilege is needed for a user to create indexes in oracle?

What is an oracle user role?

For more Oracle General Interview Questions Click Here