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 vote289 views1 answer
Install postgresql 12 on debian 10
SQL
4 votes277 views2 answers
Tables in sql
SQL
19 votes303 views5 answers
Date between in mysql
SQL
0 vote270 views1 answer
Postgresql get current user name
SQL
0 vote319 views1 answer
Is not numeric sql
SQL
0 vote337 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote288 views2 answers
How to update the multiple rows in sql
SQL
10 votes318 views4 answers
Else if mysql
SQL
0 vote307 views1 answer
Count in sql and diff
SQL
0 vote311 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL