how to find out largest value in a table

Question Posted / shabbirmca

2 Answers
4756 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

defination of bitmap index

0 Answers NIIT,

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

2 Answers Wipro,

what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .

5 Answers HCL, LN,

Why is oracle database so popular?

0 Answers

please explain.. DB architecture ...

0 Answers

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

2 Answers HCL,

Does oracle partitioning improve performance?

0 Answers

How to select all columns of all rows from a table in oracle?

0 Answers

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers

Is java required for oracle client?

0 Answers

What is private procedure oracle?

0 Answers

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

0 Answers

For more Oracle General Interview Questions Click Here