How To Use Order By Functionality In Mssql

Hello Friend Today In This Blog I Will Show You How To Use Order By Functionality In Mssql.The ORDER BY keyword is used to sort the result-set in ascending or descending order.The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.The SQL Server (Transact-SQL) ORDER BY clause is used to sort the records in your result set. The ORDER BY clause can only be used in SELECT statements.And this tutorial we will issue a variety of SELECT statements with ORDER BY clauses to show how data can be sorted in both ascending and descending.  We are going to offer examples with character, numeric and date based columns.  We will also provide some examples on combinations of these columns and ORDER BY logic.Having your data returned to you in some meaningful sorted order is important sometimes.  If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order.  To make sure a result set is ordered you need to use the ORDER BY clause.  In this article I will be exploring how to return an order result set by using the ORDER BY clause.By adding an ORDER BY clause at the end of my SELECT statement I was able to return sorted results.  My results are sorted based on StreetName in ascending order.The ORDER BY clause allows you to specify whether you want the sorted output in descending or ascending order.  If you want to explicitly tell SQL SerRows in a query result are unordered, so you should view the order in which rows appear as being arbitrary. This situation arises because the relational model posits that row order is irrelevant for table operations. You can use the ORDER BY clause to sort rows by a specified column or columns in ascending (lowest to highest) or descending (highest to lowest) order; see the “Sort Order” sidebar in this section. The ORDER BY clause always is the last clause in a SELECT statement.ver which ordering scheme to use you need to specify ASC, or DESC along with the ORDER BY clause.The default sort order is ascending.

ORDER BY Syntax

SELECT column1, column2, ...
FROM table_name

ORDER BY column1, column2, ... ASC|DESC;

Here Is An Example Related To Topic

Step 1 :Create database

Create database USERS

Step 2:Create table

Here In This step We Will Create table.

Here In This Step We Required Four Column With Name Uids ,Uname ,Ucountry and Usalary using Parameter bigint,varchar and float.

create table UserDetail
(
Uids bigint,
Uname varchar(50),
Ucountry varchar(200),
Usalary float
);

Step 3 :Create Insert Trigger Functionality

Here In This Step We Will Insert Data Using Insert Command.

Data Will Be Added Manually Using Insert Command.

Insert Into UserDetail values(1,'VIRAJ','INDIA',15000.00)

Insert Into UserDetail values(2,'RAJ','USA',10000.00)

Insert Into UserDetail values(3,'ANIL','UK',12000.00)

Insert Into UserDetail values(4,'SUNIL','CANEDA',9000.00)

Insert Into UserDetail values(5,'SHERYAS','CHINA',11000.00)

select *from UserDetail

Step 4 :Create Order By Functionality In ASC Order

Here In This Step We Will Order By Data In Ascending Order Using Order By Function In ASC Order.
Data Will Be Added Manually Using Order By Function In ASC Order.
Here Data Will Be Arange In Ascending Order Format.



SELECT * FROM UserDetail
ORDER BY Ucountry Asc;

Step 5 :Create Order By Functionality In Desc Order

Here In This Step We Will Order By Data In Descending Order Using Order By Function In DESC Order.
Data Will Be Added Manually Using Order By Function In DESC Order.
Here Data Will Be Arange In Descending Order Format.



SELECT * FROM UserDetail
ORDER BY Ucountry DESC;