Answer Posted / 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)
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
What does psql command do?
How do I remove all rows from a table?
Do indexes speed up queries?
How to create local server in postgresql?
Does postgres have clustered index?
Can primary key be null postgres?
Do provide an explanation for pgadmin?
Is postgresql a sql server?
What is a primary key constraint?
How do I start postgresql?
What is pg_hba conf file?
What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?
What is multi-version control?
What is postgis extension?
How do you create a table in pgadmin?
