hi there,
can i ask some help please.
i need to get the addon percentage on my database... add on is being computed based on the difference between an invoice and estimate.
my query goes like this:
SELECT
COUNT(estimate) as est,
SUM(invoice-estimate) as addons,
SUM(addons / est) * 100 as Percentage
FROM tblestimates
What is the best way to do this? i know that i cant use aliases on the computation i made.
Thank you
from Databases http://ift.tt/29N9dVe
via
IFTTT
Related Post
MySQL CONCAT, HAVING and JOINhi can this be use all together?
here is my query:
SELECT CONCAT(fullname," ",address1," ",city,"
Merge Various XML FilesI am looking for a program to use that will allow me to easily merge various XML files.
from Datab
What is the use of YY-DD-MM date format in sql?We are normally using the date format like DD-MM-YY.but tell me any important uses are there in the
Combine data from two rows into oneWhen I do a query, I get the following results (see attached image). I would like the January rows
Selling DumpsDumps and Cvv prices depends on country and card type. Please contact me for further details. I got
Phpmyadmin triggerHi
"A" table (sipid,totalkg)
1 ..
2..
3..
"B" table (id,sipid,kg)
1 1 500
2 1 200
3 2 150
I want s
Out Of Topic Show Konversi KodeHide Konversi Kode Show EmoticonHide Emoticon