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 vote199 views1 answer
First mysql
SQL
0 vote191 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote234 views1 answer
Sql cursor example multiple columns
SQL
0 vote198 views1 answer
Oracle job schedules
SQL
2 votes214 views1 answer
Oracle sql merge
SQL
0 vote246 views1 answer
How to check rollback status in oracle
SQL
0 vote202 views2 answers
Sql server select first day of previous year
SQL
0 vote194 views1 answer
Sql server cannot create database diagram
SQL
8 votes190 views1 answer
Oracle add month
SQL
3 votes193 views1 answer
Oracle undo tablespace list by user
SQL