摆放SQL顺序通过（简单）

Question

我试图订购以下结果的参考。使用Order by和desc限制100.有人可以帮我放置它的位置。

$stm = $pdo->prepare("SELECT `reference`, SUM(`stockdifference`) AS 'stockdifference' 
FROM `results1` 
WHERE `datum` BETWEEN '".$oldDate."' AND '".$newDate."' AND `reference` = '".$stm[0]."'"); 

Answer 1

要订购一个SQL查询很简单。

Select * 
FROM table 
Where column=condition 
ORDER BY column desc/asc 
Limit 

Answer 2

尝试：

<?php 
$stm = $pdo->prepare("SELECT `reference`, SUM(`stockdifference`) AS 'stockdifference' 
FROM `results1` 
WHERE `datum` BETWEEN '".$oldDate."' AND '".$newDate."' AND `reference` = '".$stm[0]."' 
Order by 'your column', 
'your column' desc, 
limit 100 

");