SELECT MIN(SAL) FROM (SELECT SAL FROM (select sal from emp group by sal ord

Describe the different type of Integrity Constraints
supported by ORACLE ?

Question Posted / prna

Answer Posted / prna

SELECT MIN(SAL) FROM (SELECT SAL FROM (select sal from emp group by sal order by sal desc) WHERE ROWNUM<=3)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to define a variable of a specific record type?

1085

How to open a cursor variable?

1048

How to start your 10g xe server from command line?

1076

What is proxy method?

979

What is ordinary table in oracle?

1167

Explain an extent?

1114

What privilege is needed for a user to create tables in oracle?

957

How to manage transaction isolation level?

1014

What is the difference between "as" and "is" in an oracle stored procedure?

1005

How to get execution statistics reports on query statements?

1108

How to use like conditions in oracle?

1072

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2295

Explain the dml?

992

What are temporal data types in oracle?

1130

How do I know if oracle is installed on windows?

942