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

5 votes246 views1 answer
Oracle columns in all_tables
SQL
2 votes248 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote254 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote278 views1 answer
Grant privileges of databse to user
SQL
8 votes246 views3 answers
Alter table auto_increment
SQL
0 vote253 views1 answer
Merge clause with inner join
SQL
0 vote251 views1 answer
Postgressql uuid
SQL
0 vote254 views1 answer
Sqlalchemy sequence postgresql
SQL
5 votes274 views2 answers
Mysql dump mysql db cli
SQL
4 votes271 views1 answer
Data types in sql
SQL