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 vote313 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote317 views1 answer
Duplix print in Smartforms
SQL
5 votes318 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote337 views1 answer
Date 3 months from today sql
SQL
0 vote325 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote317 views1 answer
PSQL use LIKE with timestamps
SQL
2 votes311 views1 answer
Guid to string sql
SQL
0 vote292 views1 answer
How to update random rows in sql
SQL
-1 vote332 views1 answer
Pl sql drop trigger
SQL
0 vote313 views5 answers
Select concat alter table mysql
SQL