SQL Basic- SQL ORDER BY



SQL ORDER BY


This is Keyword, Used to sort the result-set.


SQL ORDER BY Keyword


The ORDER BY keyword is used to sort the result-set by one or more columns.

The ORDER BY keyword sorts the records in ascending order by default. 

To sort the records in a ascending order, you can use the ASC keyword.

To sort the records in a descending order, you can use the DESC keyword.


Below is selection from "Student" table:






Syntax:


SELECT column_name
FROM table_name
ORDER BY column_name ASC | DESC;



Example 1:[In one column]




The following statement selects all student from the "Student" table, sorted by the "Address" column:




SELECT * FROM Student 

ORDER BY Address;



Result:






Example 2:[In two column]


The following statement selects all Student from the "Student" table, sorted DESCENDING by the "Address " column:

SELECT * FROM Student

ORDER BY Address DESC;




Result:









Example 3:[In two column]


The following statement selects all Student from the "Student" table, sorted by the "StudentName" and the "Address" column:


SELECT * FROM Student

ORDER BY StudentName, Address;



Result:



Example 4:[In two column]


The following statement selects all Student from the "Student" table, sorted ASC by the "StudentName" and DESC by the "Address" column:


SELECT * FROM Student

ORDER BY StudentName ASC, Address DESC;



Result:






Popular posts from this blog

Rules for Constructing Character Constants

Rules for Constructing Character Constants A character constant is a single alphabet. A single digit or a single special symbol enclosed within single inverted commas .  Both the inverted commas should point to the left. For example:                      ’A’ is a valid character constant whereas ‘A’ is not. The maximum length of a character constant can be 1 character. Ex.:  'A' 'I' '5' '='
Read more

My Bisalpur- Population

Population The city is divided into 25 wards for which elections are held every 5 years. The Bisalpur Nagar Palika Parishad has population of 73,551 of which 38,858 are males while 34,693 are females as per report released by Census India 2011. Population of Children with age of 0-6 is 10242 which is 13.93 % of total population. In Bisalpur, Female Sex Ratio is of 893 against state average of 912. Moreover Child Sex Ratio in Bisalpur is around 913 compared to Uttar Pradesh state average of 902. Literacy rate of Bisalpur city is 61.65 % lower than state average of 67.68 %. Male literacy is around 68.96 % while female literacy rate is 53.43 %. Bisalpur Religion Data 2011 Town Bisalpur Population 73,551 Hindu 53.54% Muslim   45.93% Christian 0.18% Sikh 0.01% Buddhist 0.01% Jain 0.01% Others 0.00% Not Stated 0.06% My Bisalpur Related Topic: My Bisalpur- Introdution ,   Bisalpur Population
Read more

How to bind dropdownlist inside gridview edit template

Image
Overview:   This article explains how to bind drop down list control which is placed inside Asp.net   Gridview  control under Edit Template. .i.e Gridview edit template dropdownlist bind. Also using  DataRowView  we able to get and set gridview edit template drop-down list value. On ".aspx" Page: Add gridview on design page like: On ".aspx.cs" Page: Page_load Bind gridview control: Yeah, we are done now :-) Hope you enjoyed this tutorial. If you have any recommendations, please let us know what you think in the comment section below! See you again next time!
Read more