The value, in this case, can either be numbers, dates or text.Ĩ. BETWEEN: As the name suggests, this operator filters the results for a particular set of ranges. It is used to fetch all the rows for the specified columns for which the data has not been found or has been found as null.ħ. IS NULL: The IS NULL operator is another SQL-based operator which is used to display whether the particular column name has a NULL value. It is more or less similar to the OR condition.Ħ. IN: The IN operator when the comparison of a column is made with multiple values. Wildcard operators such as % are used when you are not sure about the particular pattern.ĥ. LIKE: This operator is used to compare between the two conditions and lists down all the rows of a table whose column name matches the pattern specified with the LIKE clause. This is quite very similar to using a WHERE clause but this includes the use by a group function.Ĥ. HAVING: The HAVING clause is used to filter the data based on one or more group functions. DELETE: As the name suggests, this command is used to delete the rows from a table.ģ. UPDATE: This command is used to update or modify the existing rows in a table.Ģ. The intermediate commands are given below:ġ. The mandate for the INSERT command is that the table should be already created. INSERT: The INSERT command is used to add a new row of data inside the table. GROUP BY: The GROUP BY clause in the SQL commands is used to retrieve the data on the basis of some particular grouping related to one or more columns.ġ0. If no argument is given after the ORDER BY clause, it by default takes as the ascending order query.ĩ. ORDER BY: This is used along with the select statement to sort the results either in ascending order or descending order. AVG(): This is an aggregate function that is used to return the average value of a particular numeric column.Ĩ. For the row to appear in the data result set, both the conditions should be true.ħ. AND: This is an SQL operator which is used to combine two conditions. They are defined for columns and tables, which helps in increasing the readability of the query.Ħ. SQL ALIAS: The ALIAS is among the most common SQL command which is used to give a meaningful name to your attribute or a column. This is helpful as it excludes all the irrelevant data.ĥ. WHERE: The WHERE clause is one of the most important SQL commands as it is used to retrieve or fetch the specific data that is required for a particular case. It includes modifying the table as per the need.Ĥ. ALTER: This DML command is used to make alterations to the table.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |