开发者

Help with SQL query?

I have a table which has among others a column called cust_name of type开发者_运维技巧 varchar(30). I want to retrieve a list of all the name which does not contain the letter 'P' in it. what is the query I should use?


SELECT C.cust_name
FROM Customer C
WHERE C.cust_name NOT LIKE '%P%'
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜