我有下表:
CREATE TABLE Bable
(
id int identity primary key,
name varchar(20),
about varchar(30)
);
INSERT INTO Bable (name,about) VALUES
('ООО Name Firm 1','texttexttexttext'),
('ООО Name Firm 2','texttexttexttext'),
('ООО Name Firm 3','texttexttexttext'),
('ООО Name Firm 4','texttexttexttext'),
('ООО Name Firm 5','texttexttexttext'),
('ООО Name Firm $1','texttexttexttext'),
('ООО Name Firm $2','texttexttexttext'),
('ООО Name Firm $3','texttexttexttext'),
('ООО Name Firm 6','texttexttexttext'),
('ООО Name Firm 7','texttexttexttext')
我可以编写如下查询:
SELECT * FROM Bable WHERE about = 'texttexttexttext'
如何更改此查询以返回排序的结果,使得名称中包含“$”的结果首先出现,然后是不包含“$”的结果,然后按每个组排序name
上升?
表的结构在这里 http://sqlfiddle.com/#!3/14d86