DotNetShoutout - Fun with ORDER BY clause

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

6
Shouts

Shout it

Fun with ORDER BY clause

published 576 days, 21 hours, 23 minutes ago posted by

dhara 579 days, 6 hours, 18 minutes ago

You can use Ordinal position in the ORDER BY Clause for sorting the resultset. The ordinal position refers the column position in the SELECT statement. Consider the following select statement select * from ( select 17 as a,2 as b union all select 1 as...

category: Data | clicked: 21 | | source: beyondrelational.com | show counter code

tags: SQL Server, TSQL

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout