Product of 2 columns in SQL

Solved

Dd_babou -

Hello,
I would like to know how to return, in an SQL query, the product of 2 elements:
select a,b, multiplication of a by b from table ...
using something other than the exponential of the log.

7 answers

Answer 1 / 7 - Best answer
The best answer is the one that has been validated by our teams.
BlueMind
Hi,

I think it's quite simple

SELECT a, b, a * b FROM ...

--
Why bother moving mountains when it's so easy to go over them?
9
Answer 2 / 7
Dd_babou Author
I found it was really simple,
select a,b, a*b from table
2
Answer 3 / 7
Passarinho44 Contributor
Luckily you found it because we were stuck with BlueMind ;)

Good luck!
1
1. BlueMind
  
  LMAO
  Is he making fun of us or what?
  
  --
  What’s the point of moving mountains when it’s so easy to just go over them?
  
  0
Answer 4 / 7
Dd_babou Author
Thank you anyway.
1
Answer 5 / 7
Passarinho44 Contributor
SELECT a, b, c=a*b FROM table

It should work ...
0
1. BlueMind
  
  uh no, I don't think he'll accept the "c=" but if the result column must be called c then it should be
  
  SELECT a, b, a * b as c FROM table;
  
  --
  What's the point of moving mountains when it's so simple to go over them?
  
  0
2. Passarinho44 Contributor
  
  @BlueMindSorry at the moment I'm programming on software with a proprietary language and this SQL query works, I thought it worked for all SQL ^^
  
  Otherwise I agree with you on: a*b AS c
  
  0
Answer 6 / 7
Passarinho44 Contributor
LOL

Yeah, I think so ^^
0
Answer 7 / 7
tresor
here's yet another possibility

select sum(a*b) from
0

Product of 2 columns in SQL

7 answers

Autonomy

Texture issues in enshrouded

Thunderbird bug

Screen locked

Fix gigaset quicksynk not recognizing my gigaset cl660h

Toshiba laptop won’t start

Acrobat raeder

Printer that won’t start

Laptop displays a black screen and won’t boot

I can no longer access my page