sql server根据状态查询显示记录 [英] sql server query for display record as per status

问题描述

表温度

身份状态
1完成
2个已批准
3已付费
4取消
5个已批准
6已付

我想按波纹管表在上面的列中显示，而无需使用union.因为这是客户的要求，所以请为此提供帮助.

表温度

身份状态
1完成
2个已批准
5个已批准
3已付费
6已付
4 cancel

Table temp

ID Status
1 completed
2 approved
3 paid
4 cancel
5 approved
6 paid

I want to display above recored as per bellow table without using union.because this is client requirement, so please provide help for this.

Table temp

ID Status
1 completed
2 approved
5 approved
3 paid
6 paid
4 cancel

推荐答案

您需要在SELECT 查询中使用ORDER BY子句.
请参阅订购依据 [

You need to use an ORDER BY clause along with your SELECT query.
See Order By[^].

这篇关于sql server根据状态查询显示记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！