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 vote283 views1 answer
Postgres type equivalent to timespan c#
SQL
6 votes286 views2 answers
What is non relational database
SQL
0 vote262 views1 answer
Time in sql server
SQL
0 vote272 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote257 views1 answer
Opensuse status MySQL
SQL
-1 vote274 views2 answers
Get day in sql
SQL
0 vote288 views2 answers
Jsonb
SQL
0 vote297 views2 answers
Execute stored procedure without db set
SQL
0 vote262 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote312 views1 answer
For select oracle
SQL