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 vote270 views1 answer
Drop table BigQuery table columns
SQL
0 vote223 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote222 views2 answers
How to set global time_zone in mysql
SQL
2 votes228 views1 answer
Oracle convert run_duration to number
SQL
0 vote225 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote253 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote238 views1 answer
Delete duplicate rows
SQL
5 votes218 views1 answer
Oracle get foreign keys on table
SQL
1 vote221 views3 answers
What is union in sql
SQL
0 vote231 views1 answer
SQL Server date literal
SQL