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 foreign key constraint is important?
Does postgres create indexes for foreign keys?
Can primary key be null postgres?
What is postgresql? Explain the history of postgresql.
What is a postgres tuple?
Provide a brief explanation of the functions in postgresql.
What is the best postgresql gui tool?
What is the point of foreign keys?
How large can a postgresql database be?
Does postgres have clustered index?
What is the difference between oracle and postgresql?
How to connect to postgres database using pgadmin?
What is special about postgresql?
How do you change the name of a column?
Is postgresql free to use?