MySQL – WHERE Clause Table of content MySQL WHERE Clause We know that the SQL SELECT command is used to fetch records from a MySQL table. In addition to that, we can also use a conditional clause called the WHERE Clause in conjunction with the SELECT statement to filter out the results. Using this WHERE […]
Category Archives: mysql
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 […]
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. […]