Question

关于SQL中的DELETE

--select * from admin order by password collate chinese_prc_stroke_ci_as desc --update admin set password = 'admin' from admin where id=1 --update admin set password = 'password' from admin where username='username' select * from admin --insert into admin (id,username,password) values (3,'nadsaewaa','tedffdacddcher') --select top 1 (select substring(username,1,1) from admin where id=1) + (select substring(username,2,1) from admin where id =2) as 'as'from admin --update admin set id = 1 from admin where id =2 下面我想删除以ID=1倒叙,第一条记录. 我晓得DELETE中没有TOP 1这个用法.能用新手看的懂的来解决下么?

Answer 1

如果你表里没有主键的话~这个是没有办法的办法(虽然这个办法很傻~)
DELETE
FROM
TABLE_NAME
WHERE
ID
=
1
AND
USERNAME
=
(select
top
1
username
from
table_name
where
id=1
)
AND
PASSWORD
=
(select
top
1
password
from
table_name
where
id=1
)
PS:什么叫以ID=1倒叙？