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 find find & delete duplicate rows from two different tables?

what is null value?

What are inner join and outer join?

How do I find my oracle client driver version?

Define Normalization with example?

How to start your 10g xe server?

Whatz the main diff between Subquery and a Join

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

What is merge in oracle?

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

How to use group functions in the select clause using oracle?

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

For more Oracle General Interview Questions Click Here