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)

define sql insert statement ? : Sql dba

986

---

Is sql better than excel?

1080

---

How would you pass hints to the sql processor?

943

---

What is a natural join sql?

930

---

How do you explain an index?

1233

---

what are the difference between clustered and a non-clustered index? : Sql dba

993

---

How does stored procedure reduce network traffic?

980

---

Which command is used to delete a trigger?

1280

---

Which software is used for pl sql programming?

943

---

what is the stuff function and how does it differ from the replace function? : Sql dba

1003

---

what are enums used for in mysql? : Sql dba

1131

---

Difference between table function and pipelined function?

978

---

Write a sql query to convert all character to uppercase after hypen.

1391

---

what is the difference between blob and text? : Sql dba

975

---

What is a trigger word?

974

---