SQL Select
SQL SELECT NULL
First of all we should know that what null value is? Null values are used to represent missing unknown data. There can be two conditions:…
SQL Select SUM
It is also known as SQL SUM() function. It is used in a SQL query to return summed value of an expression. Let’s see the…
SQL SELECT DATE
SQL SELECT DATE is used to retrieve a date from a database. If you want to find a particular date from a database, you can…
SQL SELECT Multiple
This statement is used to retrieve fields from multiple tables. To do so, we need to use join query to get data from multiple tables….
SQL SELECT IN
SQL IN is an operator used in a SQL query to help reduce the need to use multiple SQL “OR” conditions. It is used in…
SQL SELECT AS
SQL AS is used to assign temporarily a new name to a table column. It makes easy presentation of query results and allows the developer…
SQL SELECT RANDOM
The SQL SELECT RANDOM() function returns the random row. It can be used in online exam to display the random questions. There are a lot…
SQL SELECT LAST
The last() function is used to return the last value of the specified column. Syntax for SQL SELECT LAST() FUNCTION: SELECT LAST (column_name) FROM table_name; You should note that…
SQL SELECT FIRST
The SQL first() function is used to return the first value of the selected column. Let’s see the syntax of sql select first() function: SELECT FIRST(column_name) FROM table_name;…
SQL SELECT TOP
The SQL SELECT TOP Statement is used to select top data from a table. The top clause specifies that how many rows are returned. Let’s…