Second highest Value select max(user_id) from users where user

find out the second highest salary?

Question Posted / mukesh

55 Answers
89796 Views
Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
E-Mail Answers

Answer Posted / mukesh

Second highest Value

select max(user_id) from users
where user_id < (select max (user_id) from users)

Mukesh Narayan SIngh
09873595976
mukeshnsingh22@gmail.com

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a package in oracle?

1102

What is recovery manager in Oracle?

1056

What is the usage of synonyms?

1143

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2265

How to save query output to a local file?

1027

How to use "while" statements in oracle?

1327

Why is oracle database so popular?

1002

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1051

How to use "if" statements on multiple conditions?

1174

Explain a private synonyms?

1039

How to connect to oracle using service name instead of sid?

1026

What types of joins are used in writing subqueries?

985

Does facebook use oracle?

1034

IS it possible to built the oracle database without setting the kernal parameters?

2348

What is a directory object?

1097