Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL INTERSECT

PostgreSQL INTERSECT clause/operator is used to combine the results of two or more SELECT statements with returning duplicate(COMMON) rows ONLY.
postgres=# select * from tab1; postgres=# select * from tab2;
 id | name                              id |  name  
----+-------                           ----+--------
  1 | nijam                              1 | jamal
  2 | abu                                2 | smith
  3 | umar                               4 | daniel
  7 | jamal                              5 | zaheer
(4 rows)                               (4 rows)
-- From above table  tab1 and tab2 having one duplicate values "name=jamal" is duplicate so INTERSECT  clause shows only COMMON rows (7,jamal). 
postgres=# SELECT name FROM tab1 INTERSECT SELECT name FROM tab2;

 name  
-------
 jamal
(1 row)   











Comments

Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL Database startup / shutdown /restart

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?