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 vote117 views1 answer
Sql max min
SQL
6 votes127 views2 answers
Difference between join vs union
SQL
0 vote249 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote101 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote108 views1 answer
List all permissions on a table in postgres
SQL
0 vote112 views1 answer
Pl/sql loop example
SQL
0 vote122 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote148 views1 answer
Mysl like insert a variable
SQL
0 vote120 views1 answer
Start stop mysql linux
SQL
2 votes124 views1 answer
Node and mysql like
SQL