Answer Posted / sajid siddiki

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal < = b.sal);
For Eg:-
Enter value for n: 100
SAL
---------
3700

how to rename an existing column in a table? : Sql dba

962

---

What is trigger types of trigger?

996

---

What is a .db file?

928

---

How can we link a sql database to an existing android app?

983

---

What is gpt format?

894

---

What is the sql query to display the current date?

991

---

Which is faster joins or subqueries?

931

---

where are cookies actually stored on the hard disk? : Sql dba

977

---

What is the left table in sql?

915

---

What is meaning of <> in sql?

1023

---

What is the difference between inner join and outer join?

931

---

How do you declare a user-defined exception?

965

---

What is clustered and nonclustered index in sql?

896

---

what are all the common sql function? : Sql dba

1013

---

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

1091

---