SQL Select data from a database - SQL Tutorial
The data returned is stored in a result table, called the result-set.
Basic syntax of the SELECT statement, example:
SELECT column1, column2, columnB
FROM table_name
WHERE [CONDITION|EXPRESSION];
FROM table_name
WHERE [CONDITION|EXPRESSION];
Boolean Expressions
SELECT column1, column2, columnN
FROM table_name
WHERE SINGLE VALUE MATCHING EXPRESSION;
FROM table_name
WHERE SINGLE VALUE MATCHING EXPRESSION;
There are different types of SQL expressions, which are mentioned below
- Boolean
- Numeric
- Date
Numeric Expression
These expressions are used to perform any mathematical operation in any query. Following is the syntax −
These expressions are used to perform any mathematical operation in any query. Following is the syntax −
SELECT numerical_expression as OPERATION_NAME
[FROM table_name
WHERE CONDITION] ;
[FROM table_name
WHERE CONDITION] ;
SQL Select data from a database. - sql tutorial
Online Editor
This tool makes it easy to create, adjust, and experiment with custom colors for the web.
HTML Templates
Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.
CSS HTML Layout
Find here examples of creative and unique website layouts.
Free CSS HTML Menu
Find here examples of creative and unique website CSS HTML menu.