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 vote134 views1 answer
Postgresql convert text to float
SQL
0 vote142 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote140 views1 answer
Left join in codeigniter query builder
SQL
0 vote140 views1 answer
Sql query for getting data with join and count
SQL
0 vote177 views1 answer
Psql create usr
SQL
2 votes92 views2 answers
Mysql get last character of string
SQL
0 vote140 views1 answer
Python list from sql
SQL
1 vote164 views1 answer
Oracle apex version view
SQL
2 votes183 views1 answer
Remove foreign key constraints in postgres
SQL
0 vote135 views3 answers
Get free card roblox
SQL