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 vote194 views1 answer
Add two days to current date in sql when creating tables
SQL
1 vote165 views1 answer
Oracle sql assign unique number to each grouping
SQL
4 votes155 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote169 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote191 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
3 votes174 views2 answers
Sql random integer
SQL
0 vote168 views2 answers
How to know the character set of an oracle databes
SQL
0 vote198 views1 answer
Mysql auto increment default value with prefix month and year
SQL
1 vote167 views1 answer
Sql eliminare un record
SQL
0 vote160 views1 answer
Create boolean column in MySQL with false as default value?
SQL