Answer / liju

nth lowest
nth lowest
*******************************************************
SELECT DISTINCT (A.sal) FROM EMP A WHERE (N-1) =

(SELECT COUNT (DISTINCT (b.sal)) FROM EMP B

WHERE b.sal<a.sal);

nth highest
*******************************************************
SELECT DISTINCT (A.sal) FROM EMP A WHERE (N-1) =

(SELECT COUNT (DISTINCT (b.sal)) FROM EMP B

WHERE b.sal>a.sal);

Answer / hari.sidd

SELECT DISTINCT (A.sal) FROM EMP A WHERE &N =

(SELECT COUNT (DISTINCT (b.sal)) FROM EMP B

WHERE a.sal>=b.sal);

Answer / mohd javed

For All SQL , Tested in PostgresSQL : Javedcc@gmail.com

SELECT * FROM <Table_Name> A
WHERE N = (SELECT COUNT(DISTINCT B.Column_Name ) FROM
<Table_Name> B WHERE A.Column_Name >= B.Column_Name)

Answer / ezhumalai

with cte
as
(
select Salary,row_number() over ( order by Salary asc)rnt from EMP
)select * from cte where rnt=2

Where is pgadmin installed?

0 Answers  

---

Who created postgresql?

0 Answers  

---

How do I change the order of columns in postgresql?

0 Answers  

---

What is the powerful database utility that can be used for building, executing and processing queries upon PostgreSQL databases?

0 Answers  

---

What does mvcc mean?

0 Answers  

---

How to access postgresql database from another machine?

0 Answers  

---

How do I stop a postgresql console?

0 Answers  

---

How do I change the default port for postgresql?

1 Answers  

---

Who maintains postgresql?

0 Answers  

---

What is logical replication in postgresql?

0 Answers  

---

Is postgresql case sensitive?

0 Answers  

---

How do I delete a query?

0 Answers  

---