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 vote316 views1 answer
Execut sql python
SQL
0 vote327 views1 answer
Oracle select partition
SQL
8 votes352 views3 answers
SQL column name
SQL
17 votes311 views3 answers
How to change a collumn name in sql
SQL
4 votes317 views2 answers
Show all database inside postgresql
SQL
1 vote305 views1 answer
Sql bitwise operators
SQL
4 votes312 views2 answers
Postgresql reset sequence
SQL
1 vote299 views2 answers
Pl sql case
SQL
0 vote310 views1 answer
Add column to table with default value plsql
SQL
0 vote320 views1 answer
Mysql milliseconds
SQL