sql select query选择不同的记录 [英] sql select query to select distinct records

问题描述

我有以下格式的记录：

i have records in the following format :

Style_no          Text        Age
JC001             Text1        1
JC001             Text1        1
JC001             Text1        1
JC002             Text9        9
JC002             Text9        9
JC002             Text9        9

Results Should be like this :

JC001             Text1        1
JC002             Text9        9

每个具有相同style_no列的行只能选择一次。我希望你理解我在说什么。



我想根据style_no列为上述条件编写sql查询。我尝试了很多查询但都徒劳无功。任何帮助将不胜感激..

Each row with same style_no column must be selected only once. i hope you understand what i am saying.

I want to write sql query for the above condition based on style_no column. i tried so many queries but all in vain. any help would be appreciated..

推荐答案

根据您提供的源数据，一个简单的 SELECT DISTINCT 会工作：

Given the source data you've provided, a simple SELECT DISTINCT would work:

SELECT DISTINCT
    Style_no,
    [Text],
    Age
FROM
    YourTable
;

这篇关于sql select query选择不同的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！