尝试编写一个能够获得最高和最低收入并打印帐户健康状况的查询？

作者: 故人
发布时间: 2025-01-12 02:02:37 (1天前)
转自：

2 条回复

0#
回复此人
时间 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 你要 <code> UNION ALL </code> ： </p> <pre> <code> Select TOP (5) AT.Health, PT.Revenue From Program_T PT INNER JOIN Account_T AT ON PT.AccountName = AT.AccountName Order by Revenue LIMIT 5 UNION ALL Select TOP (5) AT.Health, PT.Revenue From Program_T PT INNER JOIN Account_T AT ON PT.AccountName = AT.AccountName Order by Revenue DESC LIMIT 5; </code> </pre> </DIV>

编辑

登录后才能参与评论