Xp
자동
Free-Talk

sql 질문 또 가능할까요 ..

 
1
  606
Updated at 2020-09-24 08:59:00

<p>&nbsp;밑에 이런 테이블을 sfw로 만들었는데 이 테이블에서 오른쪽 열이 R이고 왼쪽열이 VENUS중에 1개는 없애고 나머지는 그대로 출력하고 싶습니다. 어떻게 해야할까요?
그리고 그외의 레코드는 그래도 출력해야합니다</p>
<table class="results table table-bordered table-striped" style="max-width: 100%; background-color: #ffffff; border-collapse: separate; border-spacing: 0px; width: 1648px; margin-bottom: 20px; border-left: 0px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-top-color: #dddddd; border-right-color: #dddddd; border-bottom-color: #dddddd; border-radius: 4px; color: #333333; font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px;">
<tbody>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">Sea</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">B</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9;">Cha</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9;">G</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">Nine</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">G</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9;">Gold</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9;">G</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">Rai</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">M</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9;" width="10" height="10">Gyar</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9;">M</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">Venus</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">R</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9;">Venus</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9;">R</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">Rai</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">R</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9;" width="50" height="50">Gyar</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9;">R</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">Rai</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd;">Y</td>
</tr>
<tr>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9; border-bottom-left-radius: 4px;">Dod</td>
<td style="padding: 8px; line-height: 20px; vertical-align: top; border-top-style: solid; border-top-color: #dddddd; border-left-style: solid; border-left-color: #dddddd; background-color: #f9f9f9; border-bottom-right-radius: 4px;">Y</td>
</tr>
</tbody>
</table>


4
Comments
2
Updated at 2020-09-24 04:37:30

왼쪽이랑 오른쪽 열의 값이 항상 같은가요?

그렇다면 

select

왼쪽,

arbitrary(오른쪽)

from --

group by 왼쪽

 

하시면 됩니다. 값이 다를경우가 있따면 그냥 

group by 왼쪽, 오른쪽 하시면 되요

WR
2020-09-24 09:51:23

형제님 사랑합니다 ㅠㅠ

2020-09-24 11:58:58

그냥 하는걸로 끝내지 마시고 왜 저 argument들이 table을 바꾸는지 생각해보시고 이것저것 시도해보시기 바랍니다

2020-09-24 08:53:15

distinct

글쓰기
검색 대상
띄어쓰기 시 조건








SERVER HEALTH CHECK: OK