CODEWITHSUNDEEP
pgadmin-4
JustCurious
JustCurious

Reputation: 830

cannot use multiple select queries in pgadmin4

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

Upvotes: 1

Views: 1880

Answers (1)

Murtuza Z
Murtuza Z

Reputation: 6017

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;

Upvotes: 3

Related Questions