create table emp(sal number(5,2);

how to select second mauximum value in a given table under salary column

Question Posted / ramesh

Answer Posted / ramesh

Is This Answer Correct ?

1 Yes

19 No

Please Help Members By Posting Answers For Below Questions

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2944

What is the recommended interval at which to run statspack snapshots, and why?

2897

what is normalisation?what are its uses?

2248

List out the types of joins.

1137

How to resolve the ORA-39133 error in Oracle?

1093

How to count groups returned with the group by clause in oracle?

1049

Explain what are the characteristics of data files?

1064

What is oracle thin client?

1009

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

2296

What is bulk copy or bcp in oracle?

1101

How to create a stored function in oracle?

1093

Calculate difference between 2 date / times in oracle sql?

1030

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

2324

Explain what are synonyms used for?

1024

How to drop a stored function?

1125