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
Why Update is too slow
How do I create a postgresql table using pgadmin?
Which key can be used to execute a query in the query editor?
How to change postgresql root user password?
How do you delete data on pgadmin?
How do you edit data in pgadmin?
What is a ctid?
Can we have multiple index on a table?
How do you create a table in pgadmin 4?
Do indexes speed up queries?
Is mysql a postgresql?
Is foreign key required?
What is performance_schema?
How do I connect to postgresql remotely?
What is postgresql and pgadmin?
