34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM TB A WHERE EXISTS(SELECT 1 FROM TB WHERE lotNumber=A.lotNumber AND value='SONY')
select * from table where name='MadeIn' and (value='china' or value='China')
SELECT ID,name,value,Rev
FROM TB
WHERE ID IN (SELECT ID=ID+1 FROM TB WHERE value='sony')
SELECT * FROM TB WHERE value='SORRY'