SQL Order By Clause

SQL Order By clause is used to short the data in ascending or descending order on the basis of query result. It does not short the actual table data but shorts the query result data.

The SQL Order By keyword sorts the records in ascending order by default. To sort the records in a descending order, you can use the DESC keyword.

SQL - ORDER BY Syntax:

SELECT column_name, column_name

FROM table_name

ORDER BY column_name ASC|DESC, column_name ASC|DESC;

 

Parameters

[ORDER BY Order_Item]

        Specifies the item used to sort the final query result set.

 [ASC]

        Specifies an ascending order for the query results. ASC is the default order for ORDER BY.

[DESC]

       Specifies a descending order for the query results.

EXAMPLES

Please Read the Previous Article for SQL-Table Structure  

ORDER BY ASC By Default Example

The following SQL statement selects all Employee from the " Employee" table, sorted By Default ASCENDING by the "First_name" column. If you have not use ASC or ASCENDING in Query.

SELECT * FROM [dbo].[Employee]

ORDER BY First_name;

ORDER BY ASC Example

The following SQL statement selects all Employee from the " Employee" table, sorted ASCENDING by the "First_name" column.

SELECT * FROM [dbo].[Employee]

ORDER BY First_name ASC;

ORDER BY DESC Example

The following SQL statement selects all Employee from the " Employee" table, sorted DESCENDING by the "First_name" column.

SELECT * FROM [dbo].[Employee]

ORDER BY First_name DESC;

ORDER BY ASC and DESC in Multiple Column Example

The following SQL statement selects all Employee from the " Employee" table, sorted ASCENDING by the "First_name" column and sorted DESCENDING by the "Department" column.

SELECT * FROM [dbo].[Employee]

ORDER BY First_name ASC, Department DESC;

 

 

HTTPS support to Blogspot coming in late April

Today i got this message on my Blogger Dashboard:

All visitors will be able to view your Blogspot domain blogs over an encrypted connection by visiting https://<your-blog>.blogspot.com. Existing links and bookmarks to your blogs will continue to work. As part of this change, the HTTPS Availability setting will disappear, and your blogs will always have an HTTPS version.

Solution 

You do not need to do anything for this to happen.

As you probably remember, some months ago, we started making HTTPS available on an opt-in basis for Blogspot domain blogs. Soon, all Blogspot domain blogs will get an HTTPS version regardless of opt-in, so readers can access any such blog over HTTPS if they choose to do so. 

Now BlogSpot blogs would be provided with a free SSL Certificate automatically whether you opt for it or not.

 

HTTPS stands for Hyper Text Transfer Protocol Secure. The data that is sent between client to server and particular user is secured (encrypted) and cannot be hacked or access by a third-party.

We just want to remind you the main benefits to using HTTPS over HTTP:

1. It helps check that your visitors open the correct blog and are not being redirected to a malicious site.

2. It helps detect if an attacker tries to change any data sent from Blogspot to the visitor.

3. It adds security measures that make it harder for other people to listen to your visitors’ conversations, track their activities, or steal their information.

4. it does not affects SEO and blog traffic.