how to find out largest value in a table

Question Posted / shabbirmca

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

What is a dead lock in oracle?

0 Answers

What is the difference between a primary key & a unique key?

0 Answers

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

1 Answers MasterCard,

What do you mean by a tablespace?

0 Answers

How to insert a new row into a table in oracle?

0 Answers

What is an index associated with a constraint?

0 Answers

List out the components of logical database structure of oracle database.

0 Answers

How to shutdown your 10g xe server?

0 Answers

i want department wise maxmum salary and empolyee name

9 Answers

Does oracle charge for java?

0 Answers

What are the predefined tablespaces in a database?

0 Answers

Can objects of the same Schema reside in different tablespaces.?

3 Answers

For more Oracle General Interview Questions Click Here