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

7 votes350 views1 answer
Minecraft forge server host
SQL
0 vote344 views1 answer
Implicit inner join table alias with id values
SQL
1 vote354 views1 answer
Mysql current running queries
SQL
0 vote355 views1 answer
Reset keys in sql
SQL
2 votes358 views1 answer
Oracle sql day of month from date
SQL
0 vote349 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
18 votes362 views3 answers
Find column name in database
SQL
2 votes358 views4 answers
Duplicate record mysql
SQL
0 vote340 views1 answer
What is between operator
SQL
0 vote320 views0 answer
SQL