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 vote187 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote188 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote232 views2 answers
Sql now - 1 day
SQL
10 votes206 views2 answers
Show tables in schema oracle
SQL
0 vote223 views2 answers
Sql server select first day of previous year
SQL
0 vote193 views1 answer
Import big data to mysql
SQL
6 votes257 views2 answers
Install psql mac
SQL
10 votes192 views4 answers
Primary key in sql
SQL
0 vote238 views1 answer
Pl sql search in all packages
SQL
0 vote235 views1 answer
Update sql sintax
SQL