Sometimes there is a need to fetch random record from the table. For example – You have a list of quotes stored in a table… [Read More]
SQL INSERT INTO SELECT Statement
In the previous tutorial, we learned the SQL INSERT INTO statement. In this guide, we will see a useful variation SQL INSERT INTO SELECT statement… [Read More]
SQL INSERT INTO Statement
The SQL INSERT INTO statement is used to add new records (rows) in the table. While adding a record in the table, it is not… [Read More]
SQL – Combining AND, OR and NOT together in where clause
In the last tutorial, we learned how to use logical operators AND, OR and NOT in SQL where clause. In this guide, we will learn… [Read More]
SQL AND, OR and NOT Operators with examples
In the last tutorial, we learned how to use where clause in an SQL statement. In this guide, we will learn about logical operators AND… [Read More]
SQL Syntax
A database is a organized collection of data. Data is stored in relational database in form of tables. To create, retrieve, update and delete from… [Read More]
Introduction to SQL
SQL is a language which is used to interact with relational database management system. Before we learn what is a SQL and what we can… [Read More]
SQL SELECT TOP Statement
SQL SELECT TOP statement returns the specified number of records starting from the top of the table. The SQL SELECT TOP Syntax Selects top n… [Read More]
SQL SELECT COUNT
The count() function returns the number of rows that matches the given condition. SQL COUNT() function Syntax SELECT COUNT (column_name) FROM table_name WHERE condition; SQL… [Read More]
SQL SELECT Statement
Select statement is used to fetch data from relational database. A relational database is organized collection of data. As we know that data is stored… [Read More]