Ordering the SQL result is possible by giving DESC or ASC in your query. These must be used along with ORDER BY clause. Read more.
Having Vs Where clause in SQL real usage is to filter rows on aggregate totals. Read more.
SQL Queries you can run and test in your project to update or modify existing rows in a Table.
These are best practices and guide lines to review any SQL program. The example given here is for COBOL.
SQL queries useful to check if Table exists or not in Oracle database., You can try these queries in SQL developer to know if Table is created by DBA or database administrator.
Index and Key both are different in RDBMS. Take a look all these differences quickly
Top differences between stored procedures and functions you can read and refresh quickly. Good summary for SQL developers.
Giving alias name is not only enough and you also need to know these three rules before you write your SQL query