SQL Feathers

Write a program or query to sort the list in SQL

 

In SQL Server Order By clause is used to sort records. the sort order is defaulted to ASC or ascending order. We can sort ASC or DESC in SQL server.

 

Example of sorting in Ascending

SELECT last_name
FROM tbl_EMP
WHERE employee_id > 500
ORDER BY last_name ASC;

 

Example of sorting in Descending  

SELECT last_name
FROM tbl_EMP
WHERE name = 'STK'
ORDER BY last_name DESC;

No comments:
Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest
Older Posts Home
Subscribe to: Posts (Atom)

Follow Us

  • Home
  • TSQL Interview Tips
  • TSQL Optimization
  • Using IIF In TSQL

Blogger Data

  • ▼  2022 (1)
    • ▼  June (1)
      • Write a program or query to sort the list in SQL
  • ►  2021 (3)
    • ►  July (1)
    • ►  April (1)
    • ►  February (1)
  • ►  2020 (7)
    • ►  November (3)
    • ►  October (1)
    • ►  August (1)
    • ►  July (1)
    • ►  April (1)
  • ►  2019 (7)
    • ►  December (1)
    • ►  August (1)
    • ►  July (1)
    • ►  May (2)
    • ►  March (1)
    • ►  January (1)
  • ►  2018 (13)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
    • ►  July (1)
    • ►  June (4)
    • ►  May (5)
  • ►  2017 (2)
    • ►  December (1)
    • ►  April (1)
  • ►  2015 (3)
    • ►  January (3)
  • ►  2014 (5)
    • ►  July (2)
    • ►  April (1)
    • ►  January (2)
  • ►  2013 (6)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (2)
@2013 . Powered by Blogger.