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

Explain the use of Merge statement in oracle 11g

1029

How to create lov dynamically at runtime & attach to text field?

1204

What is the simplest tool to run commands on oracle servers?

1011

What is a static data dictionary in oracle?

1115

In which language oracle has been developed?

1076

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2555

What are the numeric comparison operations?

1120

what is the difference between substr and instr function in oracle?

1091

what is the use of system.effective.date variable in oracle?

1120

What are the different types of synonyms?

1140

What are privileges and grants?

1067

Explain what are the different type of segments?

969

What is sequence?

1087

How to define a record variable to store a table row?

1058

what's query optimization and without use of IN AND Exist can we get another way data from query

2144