clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335783 fiddles created (27476 in the last week).

CREATE TABLE 廠商編碼 ([PIN碼] int, [編碼] varchar(3), [廠牌] nvarchar(5)) ; INSERT INTO 廠商編碼 ([PIN碼], [編碼], [廠牌]) VALUES (123, 'A01', N'蘋果'), (123, 'A03', N'蘋果'), (456, 'B11', N'花碩'), (456, 'B12', N'花碩'), (789, 'C77', N'三興'), (789, 'C78', N'三興'), (789, 'C79', N'三興'), (789, 'C80', N'三興') ; select * from 廠商編碼
PIN碼 編碼 廠牌
123 A01 蘋果
123 A03 蘋果
456 B11 花碩
456 B12 花碩
789 C77 三興
789 C78 三興
789 C79 三興
789 C80 三興
 hidden batch(es)