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 vote116 views1 answer
Sql where part of string match
SQL
5 votes137 views2 answers
Mysql create database charset utf8mb4
SQL
27 votes115 views4 answers
Get all tables with column name sql
SQL
0 vote109 views1 answer
Take sql dump in to file
SQL
0 vote121 views1 answer
Postgres declare variable
SQL
0 vote109 views1 answer
Psql check if value in array
SQL
8 votes118 views1 answer
Oracle all_source package body
SQL
4 votes131 views1 answer
Postgres delete last row
SQL
0 vote113 views1 answer
Mysql sum with group by
SQL
0 vote115 views1 answer
Sql query to return field name of a table
SQL