How to count with except in psql

# In case you want to count the no. of rows in your psql query which is using except

# let's say this is your original query

SELECT id from table1 except select id from table2;

# to get count do this
select count(*) from (SELECT id from table1 except select id from table2) temp;

Similar codes

0 vote102 views1 answer
Extract sql from query object sqlalchemy
SQL
9 votes103 views5 answers
Sql limit
SQL
0 vote94 views1 answer
Stuff in sql server
SQL
5 votes111 views1 answer
AND OR NOT operators sql
SQL
3 votes113 views1 answer
Postgres add not null to existing column
SQL
8 votes97 views1 answer
Alter tablespace add datafile
SQL
0 vote137 views1 answer
Tsql cte in a transaction
SQL
0 vote96 views1 answer
Postgresql remove new line from string
SQL
-1 vote105 views1 answer
Auto increment psql not primary key
SQL
0 vote94 views1 answer
Mysql start of today
SQL