Home SQL

SQL

SQL – WHERE clause

In SQL, WHERE clause is typically used in "Select" query to filter records on the basis of a particular condition. Only those records, for which condition is satisfied, will be fetched in the result. Syntax: ...

SQL Select Query

SQL Select Query or SQL Select statement is used to fetch or retrieve data stored in database. SELECT Query Syntax to fetch all the columns of a table. where SELECT is a keyword used to tell the...

Basic SQL syntax and keywords

In the previous chapter, you learned the basic introduction to SQL. In this chapter, we will go through some of the basic syntax that is used to write sql queries. Again, A table is an object which is...

SQL Tutorial

SQL: SQL stands for Structure Query Language. It is one of the most used language to perform CURD (Create, Update, Retrieve and Delete) operations in a database. This tutorial will guide you through the use of...

How to create a table in database using SQL query

Introduction: How to create a table in the database using SQL query. Below is the very basic form of creating a new table in database using SQL. "Create Table", followed by unique table name, is the...