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

1 vote224 views1 answer
Sql sort column by date
SQL
8 votes174 views3 answers
Alter table auto_increment
SQL
1 vote197 views2 answers
End mysql command
SQL
3 votes176 views1 answer
Oracle transaction commit rollback example
SQL
1 vote198 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote190 views1 answer
Modifier une valeur sql
SQL
0 vote212 views1 answer
Sql grant select only
SQL
0 vote169 views1 answer
Oracle list chain steps
SQL
14 votes179 views3 answers
Alter foreign key
SQL
0 vote298 views1 answer
Sql insert exemplo
SQL