In this post, “Specific row at the top then sort the rest result set in SQL Server“, we are going to learn that how we can order a result set in a customized way which cannot be achieved using ORDER by Clause in a simple way.
To demonstrate this, let’s create a sample table named as “tbl_Department” and insert some dummy rows in it. Below is the code to create the sample table:
IF(OBJECT_ID('dbo.tbl_Department') IS NOT NULL) DROP TABLE tbl_Department GO CREATE TABLE tbl_Department ( DeptId INT IDENTITY(1,1) NOT NULL, DeptName VARCHAR(256) NOT NULL, DeptAddress VARCHAR(512), DeptContact VARCHAR(15) ) GO
Now, add some sample rows into the table:
INSERT INTO tbl_Department (DeptName, DeptAddress, DeptContact) VALUES ('Engineering', 'New Delhi', '1234567890'), ('Human Resources', 'Chennai', '9876543210'), ('Admin', 'Kolkata', '2763282789'), ('Human Resources', 'New Delhi', '1928272727'), ('Not Assigned', 'Mumbai', '1839288976') GO
Let’s have a look at the table data now:
From … More