Total Page Preview: 000000001521
What is SQL select statement in English and Hindi
SQL seleect statement in English
SQL SELECT statement is used to retrieve data from one or more tables in a database. It is one of the most commonly used statements in SQL, and allows you to specify which columns to retrieve, as well as the conditions that the retrieved data should meet. Here is a detailed example of a SELECT statement:
Suppose we have a table named "Employees" with the following columns and data:
We can retrieve data from this table using the SELECT statement. For example, to retrieve all columns and rows from the "Employees" table, we can use the following SELECT statement:
This statement will retrieve all rows and columns from the "Employees" table:
We can also specify specific columns to retrieve using the SELECT statement. For example, to retrieve only the "Name" and "Salary" columns from the "Employees" table, we can use the following SELECT statement:
This statement will retrieve only the "Name" and "Salary" columns from the "Employees" table:
We can also add conditions to our SELECT statement using the WHERE clause. For example, to retrieve only the rows where the age is greater than 30, we can use the following SELECT statement:
This statement will retrieve only the rows where the age is greater than 30:
These are some basic examples of how to use the SQL SELECT statement. You can use more complex conditions and clauses to retrieve more specific data from your database.
SQL seleect statement in Hindi
SQL me SELECT statement ka upyog data retrieve karne ke liye kiya jata hai. Iske dwara hum ek ya ek se adhik columns ko select kar sakte hai aur ye columns hume ek naya table ya existing table se dikhayi dete hai. Iske saath hum conditions ke saath bhi data filter kar sakte hai.
Yaha ek example hai SELECT statement ka upyog karne ka:
Is statement se my_table table se column1 aur column2 select kiya jaayega, jisme column1 ke value 'value' honge.
Agar hum kisi table ke saare columns ko select karna chahte hai, to hum SELECT * ka upyog kar sakte hai:
Is statement se my_table table ke saare columns select kiye jaayenge.
Yaha ek tabular example hai SELECT statement ka upyog karke:
Assume kare ki humare paas ek students table hai jisme id, name, age aur gender columns hai aur kuch rows hai:
Ab hum chahte hai ki id, name aur age columns ko select karein jahaan age ki value 22 hai. Iske liye hum SELECT statement ka upyog karenge:
Is statement se neeche di gayi tabular data resultset mein diya gaya hai:
Ismein humne id, name aur age columns ko select kiya jahaan age ki value 22 thi.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com