我一个表:
id name
1 adf
2 fdsaf
3 fdsfdsfas
4 hugf
5 21dfs我要获得name列下所有的值,语句要为select * from testTalbe where name=
name列下所有的值无规律,不用select * from testTable where name like '%%'
SQL语句必须要为select * from testTalbe where name=开头
等号后面怎么写可以获得name列下所有的值
id name
1 adf
2 fdsaf
3 fdsfdsfas
4 hugf
5 21dfs我要获得name列下所有的值,语句要为select * from testTalbe where name=
name列下所有的值无规律,不用select * from testTable where name like '%%'
SQL语句必须要为select * from testTalbe where name=开头
等号后面怎么写可以获得name列下所有的值
-----------建表-----------
create table ta (id int ,nam nvarchar(20))
insert into ta
select 1,'adf' union all
select 2,'fdsaf' union all
select 3,'fdsfdsas' union all
select 4,'hugf' union all
select 5,'2ldfs'
------------- 语句----------
select x.* from ta x, ta y
where x.nam=y.nam
order by x.namid name
1 adf
2 fdsaf
3 fdsfdsfas
4 hugf
5 21dfs
/* 很容易实现在,你给表取表别名就可以了。*/