SQL
Pocket Dictionary
IMPORTANT SQL TERMS
ramchandrapadwal
, A
ADD COLUMN
SQL command used to add a new column to an existing database table.
AGGREGATE FUNCTION
Functions like SUM, COUNT, AVG, MAX, and MIN used to perform
calculations on groups of rows.
ALTER TABLE
SQL command used to modify an existing database table's structure,
such as adding, deleting, or renaming columns.
AND
Logical operator used in a WHERE clause to combine multiple
conditions, where all conditions must be true.
ANY/SOME
Operator used in a WHERE clause to compare a value with any value in a
list returned by a subquery.
AS
Keyword used to assign an alias to a table or column in a query, providing
a shorthand reference to it.
ASC
Keyword used in an ORDER BY clause to sort results in ascending order
(from the lowest value to the highest value).
ramchandrapadwal
Pocket Dictionary
IMPORTANT SQL TERMS
ramchandrapadwal
, A
ADD COLUMN
SQL command used to add a new column to an existing database table.
AGGREGATE FUNCTION
Functions like SUM, COUNT, AVG, MAX, and MIN used to perform
calculations on groups of rows.
ALTER TABLE
SQL command used to modify an existing database table's structure,
such as adding, deleting, or renaming columns.
AND
Logical operator used in a WHERE clause to combine multiple
conditions, where all conditions must be true.
ANY/SOME
Operator used in a WHERE clause to compare a value with any value in a
list returned by a subquery.
AS
Keyword used to assign an alias to a table or column in a query, providing
a shorthand reference to it.
ASC
Keyword used in an ORDER BY clause to sort results in ascending order
(from the lowest value to the highest value).
ramchandrapadwal
