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 vote155 views2 answers
Temp tables in sql server
SQL
3 votes145 views1 answer
Laravel database Using Named Bindings
SQL
0 vote147 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote139 views1 answer
Oracle activate program
SQL
1 vote139 views1 answer
Declare table variable
SQL
3 votes148 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote154 views1 answer
Big table in mysql
SQL
0 vote217 views1 answer
Mysql grant access to one database
SQL
0 vote220 views1 answer
Mysql disable triggers
SQL
0 vote160 views1 answer
Psql check table fields
SQL