Want another way shortcode about sqlcode

Question

please, i want find another way

example data

date	tomato	phone	book	pen
2022-05-15	2	2	3	1
2022-05-15	3	3	3	2

i see this result

date	tomato	phone	book	pen
2022-05-15	5	5	6	3

i use this

insert into sales.copy 
select date, 
       sum(tomato), 
       sum(phone), 
       sum(book), 
       sum(pen) 
from copy 
where date = '2022-05-15';

delete from sales.copy 
where date = '2022-05-15' 
LIMIT 2;

but i want another way this part short

'date, sum(tomato), sum(phone)...'

There is no short way...and you are missing group by clause — Ergest Basha
– Ergest Basha, Commented May 20, 2022 at 8:35
@jarlh LIMIT but no ORDER BY it will make sense if only one value match the criteria — Ergest Basha
– Ergest Basha, Commented May 20, 2022 at 9:31
@ErgestBasha, even less sense, since LIMIT isn't needed then. — jarlh
– jarlh, Commented May 20, 2022 at 9:33

Ergest Basha · Accepted Answer · 2022-05-20 08:34:13Z

1

So just group the result

select date, 
       sum(tomato), 
       sum(phone),
       sum(book), 
       sum(pen) 
from copy 
where date = '2022-05-15' 
GROUP BY date

edited May 20, 2022 at 8:34

Ergest Basha

9,3064 gold badges12 silver badges31 bronze badges

answered May 20, 2022 at 8:33

Thallius

2,6112 gold badges19 silver badges41 bronze badges

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

1 Comment

Ergest Basha Over a year ago

I think you are misunderstood the question ... but I want another way this part short 'date, sum(tomato), sum(phone)...'

Collectives™ on Stack Overflow

Want another way shortcode about sqlcode

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