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 vote143 views2 answers
Database owner can't create new tables postgres
SQL
6 votes1.3K views1 answer
Sql select second max
SQL
0 vote141 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote157 views1 answer
How to install Firebird
SQL
0 vote140 views1 answer
Grant privileges of databse to user
SQL
0 vote138 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote160 views2 answers
Mysql insert into multiple tables
SQL
0 vote143 views1 answer
Mysql shell ERROR: Not connected.
SQL
5 votes172 views1 answer
Oracle ora-00054 resource busy
SQL
2 votes140 views3 answers
Write sql query to find the second highest salary of employee
SQL