Showing posts with the label SQL

List of SQL Commands

Hello everyone, today we will learn list of SQL query commands. SQL is a domain-concrete language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system. Commands ALTER TABLE ALTER TABLE is used to add, efface/drop or modify columns in the existing table. It is withal used to integrate and drop various constraints on the existing table. ALTER TABLE table_name ADD column_name datatype; AND The AND operator displays a record if all the conditions separated by AND are TRUE. SELECT column1, column2, ... FROM table_name WHERE condition1 AND condition2 AND condition3 ....; AS The AS command is used to rename a column or table with an alias. SELECT UserID AS ID, UserName AS User FROM Users; AVG() SQL Server AVG() function is an aggregate function that returns the average value of a group. SELECT AVG(Salary) AS AvgSalary FROM Employee; BETWEEN The SQL BETWEEN cond