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

Explain table?

1178

What is program global area (pga) in oracle?

1092

How to get a create statement for an existing table?

1016

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1933

What is memory advisor in Oracle?

1134

How to do clean up if create database failed?

1071

What is a trace file and how is it created in oracle?

1147

What happens if the update subquery returns multiple rows?

1171

How to convert numbers to characters in oracle?

1080

How to assign data of the deleted row to variables?

1118

Can a formula column referred to columns in higher group ?

2553

Can the query output be sorted by multiple columns in oracle?

1061

How do I connect to oracle?

1080

How to create a table interactively?

1167

How to export data with a field delimiter?

1088