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

How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?

what is a view?

What are the different types of failures that occur in Oracle database?

How do I limit the number of oracle database connections generated by weblogic server?

What are the attributes that are found in a cursor?

how to get second highest sal of emp table

What is the usage of synonyms?

What is max rowid in oracle?

what are the differen between key flexifild and discriptive fiexifild.

What is meant by redo log buffer ?

What is tns entry?

How to create a testing table in oracle?

For more Oracle General Interview Questions Click Here