Add custom row when using select query

Question

So I have a table with name, quantity and price

name        quantity        price        "custom-row"
a           12              5             12*5
b           20              3             20*3
c           18              10            18*10

Is it possible to add a "custom" row when using a select query? And I want the values in that row = quantity * price. How can I do that?

Nickname_used · Accepted Answer · 2022-11-21 12:42:33Z

1

select name, quantity, price, (quantity * price) as custom_row
from table_name

you can just multiply your columns by column name and after AS sign any column name you want

edited Nov 21, 2022 at 12:42

answered Nov 21, 2022 at 12:40

Nickname_used

4383 silver badges19 bronze badges

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

3 Comments

nbk Over a year ago

please write some text to your query

Jonas Metzler Over a year ago

Why to use parentheses here?

Nickname_used Over a year ago

@JonasMetzler sorry, but I'm used to it, because I have massive select's in queries in my job, it's easier for me to see. And less likely to make a mistake (2+2)*2=8 2+2*2=6

Mitko Keckaroski · Accepted Answer · 2022-11-21 12:41:43Z

1

try this:

select name, quantity, price, quantity * price as custom-row
from table_name

you can where if needed filtering

answered Nov 21, 2022 at 12:41

Mitko Keckaroski

1,0891 gold badge10 silver badges16 bronze badges

2 Comments

Nickname_used Over a year ago

your script will not work because, a middle dash in the custom column name -

Jonas Metzler Over a year ago

If this should be an issue, the query you've shown is also incorrect since the question was "custom-row", not "custom_row". We can use quantity * price as 'custom-row', but I think the author of the question is able to set a valid alias on his/her own.

Collectives™ on Stack Overflow

Add custom row when using select query

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related