How to take the first line

maxsteven

The existing SqlServer data table (the table name is TestTable) contains the following three columns
Number Name Other
10000 Beijing, A Dou falls with the wind
10000 Hebei sfsaadf
10000 Shanxi 23424234
10001 Eat with the wind
10001 sleep haha
10005 Don't think about it 2234234
10006 hurry up 3424234
10007 Follow the wind to spread the speed
10007 324 Follow the wind
... ... ......
How do I get the following data set
Number Name Other
10000 Beijing, A Dou falls with the wind
10001 Eat with the wind
10005 Don't think about it 2234234
10006 hurry up 3424234
10007 Follow the wind and spread the speed
... ... ...

In other words, only go to the first line of the number, no matter what else

pguppgdn

Which row should be taken, is it random?

luguixnghui

Group first, and take the smallest

cv4bf5d65fd

select * from TestTable where 1 = (select count(1) from TestTable a where number = a. number and name<a. name) order by name

pguppgdn

select * from table
where number in
(
select min(number) from table
)

wobanima

select *
from table name as b,
(
select number, min (name) as name
from table name
group by number
) as a
where a. number = b. number and a. name = b. name

不悔不牛

select number, name, other
from TestTable
where number in(select number, min(name) as name
from table name
group by number)

我是杀人狂

select * from tablename where other in(select top 1 other from tablename group by number order by other desc)