cannot use multiple select queries in pgadmin4

Question

Is it that pgadmin 4 does not support the execution of multiple select queries?

I tried executing this query

select cust, prod 
from sales;

select * 
from sales

it only showed me one table

If you found my answer helpful then could you accept it using checkmark? — Murtuza Z
– Murtuza Z, Commented Oct 5, 2017 at 17:35

Murtuza Z · Accepted Answer · 2017-10-03 10:44:42Z

3

You are missing semicolon after first query which is incorrect SQL syntax.

select cust, prod 
from sales;

select * 
from sales;

FYI, do not expect two separate results after executing it in query tool, you will only get result from last query only.

Updates for WITH clause question.

with Min_cust as (
        select cust, max(quant),min(quant) from sales group by cust
    ),
    FinalMin as (
        select sales.cust,sales.prod,minium from sales 
        natural join Min_cust as A where sales.quant=A.min
    ) 
    select * from FinalMin;

edited Oct 3, 2017 at 10:44

answered Oct 2, 2017 at 18:02

Murtuza Z

6,0951 gold badge32 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JustCurious Over a year ago

Thanks that solved the problem. I am also getting an error when i use 2 with queries consecutively. with Min_cust as (select cust, max(quant),min(quant) from sales group by cust); with FinalMin as (select sales.cust,sales.prod,minium from sales natural join Min_cust as A where sales.quant=A.min) select * from FinalMin; can you please help me with this @n33rma

Collectives™ on Stack Overflow

cannot use multiple select queries in pgadmin4

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related