Java JDBC SQL Sorting Column Order By Clause | Java @ Desk
Home » » Java JDBC SQL Sorting Column Order By Clause

Java JDBC SQL Sorting Column Order By Clause

Java JDBC SQL Sorting Column Order By Clause
Sorting a column is done using the Order By clause in SQL. Sorting a column can be done using following keyword:
1) Order By <COLUMN_NAME> asc - Display the result in ascending order for the <COLUMN_NAME>
2) Order By <COLUMN_NAME> desc - Display the result in descending order for the <COLUMN_NAME>


SELECT col_name FROM table_name ORDER BY col_name ASC:
SELECT col_name FROM table_name ORDER BY col_name DESC:

Consider the below table:
Customer
CustId CustName
1 Cynthia
2 Thanh
3 Peter
4 Eric




Below Query will display the records in ascending order for CustName Column

SELECT * FROM Customer ORDER BY CustName ASC:
CustId CustName
1 Cynthia
4 Eric
3 Peter
2 Thanh



Below Query will display the records in descending order for CustName Column

SELECT * FROM Customer ORDER BY CustName DESC:
CustId CustName
2 Thanh
3 Peter
4 Eric
1 Cynthia





0 comments:

Post a Comment