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

Which environment variables are absolutely critical in order to run the OUI?

2071

Is there a function to split a string in plsql?

983

What is blob datatype?

1056

Give the various exception types.

949

Explain the use of online redo log files in oracle.

993

What are the different types of trigger and explain its various uses and functions?

1010

When do you get a .pll extension in oracle?

1078

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2130

How to open and close an explicit cursor in oracle?

1002

what is a Nested Loop join?

2041

What is connection pooling in oracle?

914

What do you mean by merge in oracle and how can we merge two tables?

1003

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2219

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

953

How to generate query output in html format?

1036