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

23 votes136 views3 answers
Sql where contains part of string
SQL
0 vote129 views1 answer
Price-colour
SQL
0 vote130 views1 answer
How to install mysql without admin rights
SQL
3 votes138 views1 answer
Oracle user quota on tablespace
SQL
0 vote133 views1 answer
Soql queries for not contact related account records in salesforce
SQL
1 vote146 views2 answers
Select into temp table
SQL
0 vote181 views1 answer
Table structure in sql
SQL
1 vote137 views1 answer
Select tables with name like mysql
SQL
5 votes119 views1 answer
Oracle get nls settings
SQL
1 vote135 views1 answer
Sql try catch
SQL