Category Archives: SQL

SQL CREATE Table

After creating and selecting a database using CREATE and USE commands now we can create a table inside that database, and keep remember we can create more than one table in a single database. What is a Table in the Database? A table is a collection of rows and columns which form cells like structure and the data… Read More »

SQL – Operators

In SQL we have various operators to perform operations on data, and an operator can be represented by a special symbol or by a reserved character. Operators always used along with the SQL statements and they come very handy to perform reading and writing operations. The operators in SQL are divided into 3 major categories: Arithmetic operators Comparison… Read More »

SQL Expression

When we use two or more than two combinations of values, operators and SQL functions, then it is considered as an expression. We write an expression as a statement or query which act as a formula to show some output. We often use various expressions to query a database. Expression Syntax SELECT column_name_1, column_name_2, column_name_N FROM table_name WHERE… Read More »