PROC SQL; SELECT MAX(SALARY) FROM RIGHTMER1 WHERE SALARY

find out the second highest salary?

Question Posted / radhiv kumar

Answer Posted / radhiv kumar

PROC SQL;
SELECT MAX(SALARY) FROM RIGHTMER1
WHERE SALARY < SELECT MAX (SALARY)FROM RIGHTMER1;
QUIT;

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to assign data of the deleted row to variables?

1075

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2120

What is the difference between postgresql and oracle?

1048

What is the difference between substr and instr?

1037

What is analyze command used for?

1070

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1932

What is a dead lock in oracle?

1120

How can we delete duplicate rows in a table?

972

How to define a data field as not null?

1107

What are the various types of snapshots ?

1027

How to concatenate two text values in oracle?

1112

what are the default admin accounts in Oracle 10g ?

967

What is the database name in oracle?

1021

Where do we use decode and case statements?

1011

How would you begin to troubleshoot an ORA-3113 error?

2077