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

3 votes113 views1 answer
Select database in sql
SQL
13 votes98 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote104 views1 answer
Oracle job class
SQL
3 votes116 views1 answer
Select sequence oracle
SQL
0 vote113 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote111 views1 answer
Convert polygon to text in mysql
SQL
0 vote105 views1 answer
Sql get user account
SQL
0 vote105 views1 answer
Oracle current timestamp insert statement
SQL
0 vote111 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote117 views1 answer
Laravel migration sql dump
SQL