![]() It is a function that takes the name of a column as an argument and counts the number of rows when the column is not NULLĬREATE TABLE table_name ( column_1 datatype, column_2 datatype, column_3 datatype) SELECT COUNT(column_name)FROM table_name It is a statement used to create different outputs inside a SELECT statement SELECT column_name,CASEWHEN condition THEN ‘Result_1’WHEN condition THEN ‘Result_2’ELSE ‘Result_3’ENDFROM table_name It is an operation used to filter the result within a certain range SELECT column_name(s)FROM table_nameWHERE column_name BETWEEN value_1 AND value_2 It is used to aggregate a numeric column and return its average ![]() It is a keyword in SQL that is used to rename a column or table using an alias name SELECT column_name AS ‘Alias’FROM table_name It is an operator that is used to combine two conditions SELECT column_name(s)FROM table_nameWHERE column_1 = value_1 AND column_2 = value_2 It is used to add columns to a table in a database ALTER TABLE table_name ADD column_name datatype
0 Comments
Leave a Reply. |