Select statements is used to query data from tables and views. Example: Column Concatenation The SQL statement returns the values of the first_name and last_name lines in one column, and the email column in the other line. SELECT first_name || ‘ ‘ || last_name, email FROM customer; Alias An alias is given to the column … Select
When you query data from a table, the SELECT statement returns rows in an irregular order. The ORDER BY statement is used with the SELECT clause to sort the rows in the result set. The ORDER BY statement allows you to sort the rows returned by a SELECT clause in ascending or descending order based … Order By – Listing Query Result in a Specific Order
The DISTINCT statement is used in a SELECT clause to remove duplicate rows from a result set. The DISTINCT statement keeps one row for each duplicate group. It can be applied to one or more columns in the SELECT clause’s selection list. If you specify multiple columns, the DISTINCT statement evaluates the copy based on … Removing Duplicate Rows from the Result Set (Distinct)