我在哪里按查询排序？ [英] Where To I Put Order By Query?

问题描述

以下是我的查询。现在我需要按升序订购lupname。我在哪里可以将ORDER BY放在下面的查询中

 选择 t1 。 date   as   DATE ，t1.lupname  as  LUBNAME，t1.closingstock  as  STOCK  from  lub t1  INNER   JOIN （选择 lupname ，MAX（ DATE ） DATE  来自 
 lub  GROUP   BY  lupname）t2  ON  t1.lupname = t2.lupname  AND  t1.date = t2。 date  

谢谢

Siva

解决方案

At结束...

 选择 
 t1。 date   as   date ，
 t1.lupname  as  lubname，
 t1.closingstock  as  stock 
 来自 lub t1 
 内部  join （选择 lupname，max（ date ） date  来自 lub  group   by  lupname）t2  on  t1.lupname = t2.lupname 和 t1.date = t2。 date  
 订单 按 
 t1.lupname 

Below is my query. Now i need to order lupname in ascending order. Where can i put ORDER BY in the below query

select t1.date as DATE, t1.lupname as LUBNAME,t1.closingstock as STOCK from lub t1 INNER JOIN( select lupname, MAX(DATE) DATE from
    lub GROUP BY lupname) t2 ON t1.lupname=t2.lupname AND t1.date=t2.date

Thanks
Siva

解决方案

At the end...

select 
	t1.date as date, 
	t1.lupname as lubname,
	t1.closingstock as stock 
from lub t1 
	inner join( select lupname, max(date) date from lub group by lupname) t2 on t1.lupname=t2.lupname and t1.date=t2.date
order by
	t1.lupname

这篇关于我在哪里按查询排序？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！