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

2 votes210 views2 answers
Get all tables using like
SQL
0 vote196 views1 answer
Mysql date minus 1 day
SQL
0 vote217 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote224 views1 answer
How to get data from 2 database
SQL
0 vote230 views1 answer
How to get table id sequence postgres
SQL
1 vote211 views2 answers
Sql server concat string and int
SQL
4 votes200 views4 answers
Start mysql
SQL
0 vote201 views1 answer
Number(10 2) in sql means
SQL
4 votes193 views4 answers
Print pl sql
SQL
0 vote227 views1 answer
Play framework connection via windows sql server
SQL