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 vote376 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
9 votes344 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote438 views1 answer
Delet all record statment sql
SQL
12 votes348 views4 answers
How to take database dump in postgresql
SQL
0 vote314 views1 answer
Sqldf change user
SQL
0 vote483 views1 answer
Sql insert exemplo
SQL
0 vote334 views1 answer
Syntax for changing column size in mysql
SQL
1 vote337 views2 answers
Sql example query
SQL
3 votes323 views3 answers
Mysqldump: couldn
SQL
1 vote364 views5 answers
What is in operator in sql
SQL