SQL Queries in DBMS | Single Table Retrieval | select from where in sql

Queries in SQL | Single Table Retrieval | select from where in sql
Welcome to this video on Queries in SQL | select from where in sql.
Queries in SQL are the means to retrieve data from the existing tables in sql.
Queries in SQL can be solved in so many ways, in this video of Queries in SQL , we had mentioned the way, to retrieve data from a a single table in sql.
please watch full video to learn, how to solve Queries in SQL.
After watching this video of Queries in SQL, you will be able to solve single table based queries in sql.
To solve Queries in SQL or to retrieve data from a table in sql, we have to use select from where clause of sql.
select from where in sql is useful to retrieve data from a table.
The General syntax of select from where clause in sql is – select column1,column2… from table-name [where condition];
Here select is a keyword of sql. SELECT identifies what columns to retrieve; FROM identified which table to retrieve.
We can retrieve data in many ways using select from where in sql.
We can retrieve all the data of a table using select from where clause.
we can retrieve particular rows of a table using select from where clause in sql.
we can retrieve data from particular columns of a table using select from where clause of sql.
we can retrieve data from particular rows as well as from particular columns too using select from where clause of sql.
You can select all the data from a table in sql as select * from table-name;
example: Suppose the Queries in SQL is to select all the data of a given table.
We have to supply - select * from employees;
Here name of the table is employees.
Few examples of queries in sql:
Give name of all the employees.
Give name of all the employees whose city is yamuna nagar.
Give name and salary of all the employees;
Give name and city of all the employees whoes salary is greater than 50000.

-~-~~-~~~-~~-~-
Please watch: "PRIME Number Program in C Language in Hindi video"
-~-~~-~~~-~~-~-