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 various constraints used in SQL?

Explain about integrity constraint?

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

How to remove a row in a database table?

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

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

What is a nested table?

What is the dynamic sql in oracle?

where we have to use ON clause and where we have to use USING clause in JOINS

How to write a query with a right outer join in oracle?

How to create an oracle database manually?

How to loop through a cursor variable?

For more Oracle General Interview Questions Click Here