SQL SELECT from Multiple Tables

It’s very common need to select data from more than one tables in SQL. In this tutorial, we will check how to select data from the multiple tables with syntax and examples. SQL Joins are used to get data from … Read more »

SQL SELECT IN

SQL SELECT IN operator allows to test if an expression matches any values in a list of values. This is generally used to reduce the use of multiple OR conditions in a SELECT, INSERT, UPDATE and DELETE statement. SQL SELECT … Read more »

SQL SELECT AS

Learning Objective: In this tutorial you will learn what is SQL SELECT AS and how to use it in SQL statement. SQL SELECT AS is used to rename a table column into a meaningful name in the result set. There … Read more »

SQL SELECT LIMIT

SQL SELECT LIMIT used to select records from one or more tables and limit the number of rows based on the provided value. Note that SELECT LIMIT is not supported by all the databases. For Microsoft Access or SQL Server … Read more »

SQL SELECT RANDOM

SQL SELECT RANDOM() function is used to select random rows from the result set. This is useful to select random question in online question.  There are many different ways to select random record or row from a database table. Each … Read more »

SQL SELECT LAST

The SQL LAST() function returns the last value of the selected column. SQL SELECT LAST Syntax Let’s check the syntax of the SQL SELECT LAST() function: SELECT LAST(column_name) FROM table_name; In this syntax, The function LAST() takes column_name as a parameter. column_name – … Read more »

SQL SELECT FIRST

The SQL FIRST() function returns the first value of the selected column. SQL SELECT FIRST Syntax Let’s check the syntax of the SQL SELECT FIRST() function: SELECT FIRST(column_name) FROM table_name; In this syntax, The function FIRST() takes column_name as a … Read more »

SQL SELECT TOP

The objective of this tutorial is to provide you the clear idea about SQL SELECT TOP statement with syntax and example. The SQL SELECT TOP statement returns limited rows, specified in the TOP clause as a fixed value or percentage … Read more »

SQL SELECT COUNT

In this SQL tutorial, you are going to learn how to use SQL SELECT COUNT Function along with syntax and examples. SQL COUNT Function is used to find the number of record returned in the result set. This function is … Read more »

SQL SELECT DISTINCT

SQL SELECT DISTINCT: The aim of this tutorial is to teach you how to use the SQL SELECT DISTINCT clause along with syntax and examples. The SQL SELECT DISTINCT clause is used to remove the duplicate records from the result … Read more »