Tell me how to make a request so that it is sorted by the sum of two fields, for example:
SELECT "name","prais1","prais2" FROM "tovari", I need the query to be sorted in ascending order prais1+prais2
PashaPash ♦
42.4k 10 golden marks 64 silver marks 130 bronze marks
amn111 amn111
6 2 bronze marks
- close the question - FoxManiac
|
2 answers
SELECT name, paris1, paris2, (paris1+paris2) as paris FROM `tovari` ORDER BY paris PashaPash ♦
42.4k 10 golden marks 64 silver marks 130 bronze marks
Yoharny Babai Yoharny Babai
3.145 3 gold marks 25 silver marks 48 bronze marks
- thank you so much - amn111
|
SELECT name, prais1, parais2, SUM(prais1 + parais2) as myfield FROM tovati ORDER BY myfield PashaPash ♦
42.4k 10 golden marks 64 silver marks 130 bronze marks
ilovetrancekrsk ilovetrancekrsk
525 3 silver marks 7 bronze marks
- oneAt the same time))) - Yoharny Babai
- Is the answer correct? ) - FoxManiac
- Probably have not checked yet) - Yoharny Babai
- There is no base at hand. Try adding GROUP BY SELECT name, prais1, parais2, SUM (prais1 + parais2) as myfield FROM tovati GROUP BY name ORDER BY myfield - ilovetrancekrsk
|