SQL Queries

Sql queries are used for accessing data from database as per user demand.We learn following queries.

Select all records from database-:

If we want to access all records from table then we use following qurey.

syntax-:

For eg.

In above example we create Student information table and display all records present in student information table.

Select with a’ where’ clause-:

‘where’ clause is used to access specific data from table. When we use ‘where’ clause we can also the give condition. It display records according to given condition.

Syntax-:

For eg.

In above example we can display records using ‘where’ clause.We display Student name and class which belongs to CSE department.

Left join-:

Left join is used to display matching record from two different tables.It display all records from left table and matching records from right table.

Syntax-:

For example

Right join-:

Right join is used to display matching record from two different tables.It display all records from right table and matching records from left table.

Syntax-:

Select with wildcard-:

‘Wildcard’ is used to display specified pattern in column. wildcard is with LIKE oprator.

Syntax-:

For eg.

In above table display customer imformation whose name start from ‘raj’.

Must watch the following video for understanding SQL.

Related posts:

VideoHive Creative Wall Gallery is a creative wall gallery that can be used to showcase your photos, videos, and other creative work. The gallery is easy to customize and comes with a help file…

A particular user base of Current Affairs is adding up on Revidly. A separate clan is designated for this purpose. Many users visit the platform on a regular basis, every night, just to get the…

As the COVID-19 coronavirus disease continues its onslaught on the world’s population, there is widespread talk of a “new normal”. For sure, things will not be as they were prior to the pandemic, but just how different will they be? Education; Transportion; Remote work;