create table callRecords ( srNo int identity(1,1), mode varchar(20) ) <pre lang="sql"> insert into callRecords values ('Email') insert into callRecords values ('Telephone') insert into callRecords values ('Others') insert into callRecords values ('fax') insert into callRecords values ('paper') select * from callRecords </pre>
SELECT * FROM callRecords ORDER BY CASE WHEN SrNo=3 THEN 1 ELSE 0 END, SrNo
SrNo
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)