Answer Posted / bibu

This IS HELP FULL 1ST ,2ND,3RD,4TH ANY HIGHEST SALARY U WRITE THIS QUERY.

SELECT * FROM Table_Name ALIAS_NAME 1
WHERE &N=(
SELECT COUNT(DISTINCT(WHICH COL U WANT THAT COL_NAME))
FROM Table_Name ALIAS_NAME 2
WHERE ALIAS1.CoL<=ALIAS2.Col
)

EX:
SELECT * FROM Emp E1
WHERE &N=(SELECT COUNT(DISTINCT(Sal))
FROM Emp E2
WHERE E1.Sal<=E2.Sal)

What is an example of translating a date into julian format?

1124

---

What is pl/sql language case sensitive?

1132

---

Is like operator in sql case sensitive?

1031

---

How many postgresql users are there, worldwide?

1068

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1136

---

What is type and rowtype in pl sql?

1021

---

What is trigger with example?

1104

---

If a cursor is open, how can we find in a pl/sql block?

1167

---

Where do we use pl sql?

1003

---

How do I add a primary key to a table?

1044

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

1084

---

What are the three forms of normalization?

1048

---

How does one load ebcdic data? : aql loader

1178

---

what is rollback? : Sql dba

1115

---

How much does sql certification cost?

1095

---