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

14 votes168 views3 answers
How to add default constraint in mysql
SQL
1 vote207 views1 answer
How to select random rows from a table
SQL
0 vote141 views1 answer
Get only first row mysql
SQL
1 vote231 views1 answer
Sql server delete top 1000
SQL
1 vote158 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote169 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote149 views1 answer
Changer un mot de passe mysql
SQL
0 vote155 views2 answers
Sql select inside select
SQL
1 vote139 views1 answer
Jooq convert using gbk
SQL
0 vote154 views1 answer
Oracle last connection
SQL