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 vote222 views1 answer
Mysql two joins
SQL
0 vote216 views1 answer
Oracle get running queries
SQL
0 vote188 views0 answer
SQL
0 vote230 views1 answer
Mysql select smaller of two values
SQL
1 vote234 views1 answer
Change old domain to new domain name wordpress
SQL
1 vote222 views1 answer
Oracle create index if not exists
SQL
0 vote215 views1 answer
Postgresql regular expression special characters
SQL
0 vote223 views2 answers
Soql last year
SQL
0 vote189 views1 answer
Query for maximum salary
SQL
0 vote221 views2 answers
Sql server select where date
SQL