回答編集履歴

1

表示調整

2019/05/15 09:52

投稿

yambejp
yambejp

スコア114572

test CHANGED
@@ -89,3 +89,35 @@
89
89
 
90
90
 
91
91
  ```
92
+
93
+
94
+
95
+ # 表示調整
96
+
97
+ ```SQL
98
+
99
+ set @no=null,@name=null;
100
+
101
+ select
102
+
103
+ if(@no=no,'',@no:=no) as no,
104
+
105
+ if(@name=name,'',@name:=name) as name,
106
+
107
+ val from(
108
+
109
+ select no,name,sex as val,1 as sort1,0 as sort2 from member
110
+
111
+ union all
112
+
113
+ select t1.no,t1.name,t3.data_name,2,t2.like_no from member as t1
114
+
115
+ inner join like_member as t2 on t1.no=t2.like_member_no
116
+
117
+ inner join like_data as t3 on t2.like_data_no=t3.data_no
118
+
119
+ ) as sub
120
+
121
+ order by sub.no,sub.sort1,sub.sort2;
122
+
123
+ ```