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 vote343 views1 answer
Closure in sql
SQL
4 votes353 views2 answers
Oracle unlock account
SQL
2 votes384 views1 answer
Sql compare strings
SQL
13 votes356 views2 answers
Get date from now() mysql
SQL
1 vote321 views1 answer
Mysql Case sum
SQL
0 vote315 views1 answer
Select last 2 characters sql
SQL
17 votes324 views3 answers
How to change a collumn name in sql
SQL
1 vote355 views1 answer
Second last highest id in sql
SQL
10 votes357 views1 answer
Oracle view dependencies
SQL
0 vote358 views1 answer
SQLServerException.makeFromDatabaseError
SQL