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 votes126 views1 answer
Oracle ora-00054 resource busy
SQL
1 vote133 views1 answer
Mysql how to truncate table with foreign keys
SQL
1 vote135 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
18 votes114 views3 answers
Mysql number format
SQL
2 votes117 views4 answers
Mysql select into new table
SQL
1 vote121 views1 answer
Mysql remove last empty newline
SQL
1 vote109 views1 answer
Create table tablename as select * from tablename
SQL
4 votes153 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote116 views2 answers
Many to many flask-sqlalchemy
SQL
3 votes121 views1 answer
Sql server version query
SQL