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 vote121 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote135 views1 answer
Mysql shell set time_zone
SQL
0 vote128 views1 answer
Console output pl sql
SQL
0 vote126 views1 answer
Oracle gather table statistics
SQL
0 vote159 views1 answer
How to find unique element in sql
SQL
0 vote124 views1 answer
Where in clause tsql
SQL
0 vote137 views1 answer
Mysql create pool
SQL
7 votes128 views1 answer
Sql server convert string to date
SQL
0 vote136 views1 answer
Plpgsql raise notice
SQL
0 vote129 views1 answer
How to declare variable date in mysql
SQL