Author Archives: user

MySQL – Distinct Clause Table of content MySQL DISTINCT clause The DISTINCT clause in MySQL is used with a SELECT statement to return the distinct values (unique values) from a single or multiple of columns in a table. It ignores all the duplicates values present in the particular column(s) and returns only the distinct values. […]

MySQL – ORDER BY CLAUSE Table of content MySQL ORDER BY Clause The MySQL ORDER BY clause is used to sort one or more columns of a table in provided order that can be either ascending or descending order. By default, it sorts the column(s) in ascending order if the sort order is not specified. […]

MySQL – Limit Table of content MySQL Limit Clause The LIMIT clause in MySQL can be used to specify the number of records to return. This clause is mostly used when dealing with tables that have thousands of records. It accepts one or two arguments (offset or count). The values of both arguments should be […]