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 vote271 views1 answer
Greater than or equal to symbol in postgres
SQL
1 vote281 views1 answer
Oracle transaction rollback not working
SQL
0 vote284 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote271 views1 answer
Mysql type for large numbers with many decimal
SQL
6 votes317 views2 answers
How to get last element sql
SQL
0 vote288 views1 answer
Sql quary stuf
SQL
6 votes267 views4 answers
Delete table sqlite
SQL
1 vote287 views1 answer
Tsql replace value in json
SQL
2 votes284 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote326 views1 answer
ALV GRID events
SQL