Diksha IT Training Centre

  Order By and Distinct Clause in Oracle.   Today I will discuss about SQL Order by and Distinct Clause which is vastly used in SQL query to perform Operation in query. I suggest you to please see my previous blog for your reference First start with Order By clause with Syntax and example. Order by Clause: ORDER BY clause is used to sort the records in the result set for a SELECT statement. Order by clause is used to sort the result-set in ascending or descending order. The Order By clause sorts the records in ascending order by default. To sort the records in descending order, use the DESC command in SQL. The Syntax of Order by Clause in SQL is as below: SELECT expression FROM table_name [WHERE conditions] ORDER BY expression [ ASC | DESC ];   In Above syntax : Expression: We need to specify the columns that will be retrieved or also we can use function for calculation to retrieve the column. Table_name : Table is object which stored in the database , we