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

What port does postgres use?

0 Answers  

---

Are postgres table names case sensitive?

0 Answers  

---

Is postgresql distributed?

0 Answers  

---

How do I create a foreign key in postgresql?

0 Answers  

---

What are the various enhancements to the straight relational data model by PostgreSQL?

1 Answers  

---

Is postgres a database?

0 Answers  

---

Is primary key indexed by default?

0 Answers  

---

What is a delete query?

0 Answers  

---

How does clustering in improving the performance?

0 Answers  

---

What do you mean by catalog?

0 Answers  

---

What are the different data types supported by PostgreSQL?

1 Answers  

---

How do I start a pgadmin server?

0 Answers  

---