how to find out largest value in a table

Question Posted / shabbirmca

2 Answers
4843 Views
I also Faced
E-Mail Answers

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

Post New Answer

More Oracle General Interview Questions

Explain an exception?

0 Answers

Youre getting high busy buffer waits - how can you find whats causing it?

1 Answers

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers AppLabs,

What is oracle datasource?

0 Answers

What is the difference between SQL, DDL, and DML?

7 Answers BeBo Technologies, Wipro,

select trunc(round(156.00,-1),-1) from dual;

2 Answers

How to update values on multiple rows in oracle?

0 Answers

What is java oracle used for?

0 Answers

Who i will insert 1 lacks record in a Database table

4 Answers TCS,

does the query needs a hint to access a materialized view?

0 Answers

candidate key is subset of super key but not vice-verse explain

0 Answers

What is STATSPACK tool?

3 Answers Wipro,

For more Oracle General Interview Questions Click Here