Answer Posted / s. syam sundar

1.SELECT LEVEL,MAX(SAL) FROM EMP WHERE LEVEL = 2 CONNECT BY
PRIOR SAL >SAL GROUP BY LEVEL
2.SELECT SAL FROM (SELECT SAL FROM EMP ORDER BY SAL DESC)
WHERE ROWNUM <3
MINUS
SELECT SAL FROM (SELECT SAL FROM EMP ORDER BY SAL DESC)
WHERE ROWNUM = 1
3.SELECT MAX(SAL) FROM EMP WHERE SAL <> (SELECT MAX(SAL)
FROM EMP)

regards
syam sundaar

What is the limitation on the block size of pl/sql?

960

---

What sql database should I use?

1096

---

How exception is different from error?

986

---

What is trigger types in sql?

966

---

Which sql statement is used to delete data from a database?

920

---

what are the 'mysql' command line arguments? : Sql dba

1104

---

What is the difference between mdf and ndf files?

1082

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

978

---

Can you have more than one trigger on a table?

963

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1551

---

What is trigger and types?

984

---

Why we use cross join?

916

---

What do you mean by field in sql?

1053

---

What is sql query limit?

930

---

What is fmtonly in sql?

1033

---