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 vote282 views1 answer
Call procedure in wordpress
SQL
2 votes282 views1 answer
Sql server conection string
SQL
0 vote243 views1 answer
Now() -1 mysql
SQL
0 vote281 views1 answer
How to open mysql in docker
SQL
0 vote232 views1 answer
Mysql collation for all languages
SQL
0 vote298 views1 answer
Sql cnvert bit to nvarchar
SQL
1 vote296 views1 answer
Mysql not supported auth mode
SQL
0 vote281 views1 answer
Postgresql create user roles
SQL
0 vote295 views1 answer
Oracle dynamic select into
SQL
2 votes343 views1 answer
Find column in all stored procedures sql server
SQL