Breaking News: Grepper is joining You.com. Read the official announcement!

how to count with except in psql

iamabhay answered on November 17, 2021 Popularity 1/10 Helpfulness 1/10

answer how to count with except in psql

how to count with except in psql

Comment

# 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;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: count except psql sql

Link to this answer
Share Copy Link

Contributed on Nov 17 2021

iamabhay

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

how to count with except in psql

Contents

More Related Answers

how to count with except in psql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.