Today I come across with a complex sql query requirement where I have to filter a table on a column entry and then sort according to date. The SQL language have some inbuilt keywords like ORDER to sort out this type of issues.

Let use have below table for our practice purpose

For ascending order use below code
select * from table where column_name1='value1' order by table.column_name2 ASC

Example:

For descending order use below code
select * from table where column_name1='value1' order by table.column_name2 DESC

​Example:

 

Related concept:   How To Install Oracle On RHEL5?