Total Page Preview: 000000003796
What is SQL where clause in English and Hindi
SQL where clause in English
SQL WHERE clause is used to filter the rows based on specific conditions. It is often used with the SELECT statement to retrieve only the rows that meet the specified criteria.
Here is an example of a SQL query that uses WHERE clause to filter data:
This query will retrieve all the rows from the customers table where the country column is equal to 'USA'. The * symbol is used to select all columns in the customers table.
Here's an example of how the SQL WHERE clause can be used with a table:
Consider a table named "employees" with the following columns:
Here's an example of how the SQL WHERE clause can be used to filter the rows based on specific conditions:
This query will retrieve the emp_id, first_name, last_name, and salary columns from the employees table where the department column is equal to 'IT' and the age column is less than 30.
The result of the query would be:
Note that the WHERE clause filters out the rows that do not meet the specified criteria, so only the row where the employee's department is 'IT' and age is less than 30 is returned in the result.
SQL where clause in Hindi
SQL WHERE clause ek filtering condition ko table ke rows ke saath apply karne ke liye use hota hai. Yeh condition table se data filter karne ke liye use kiya jata hai.
Iska ek example table ke saath niche diya gaya hai:
Consider a table named "students" with the following columns:
Yeh table students ki information ko darshata hai.
Ab ek SQL WHERE clause ka example lete hain:
Yeh query students table se data retrieve karega jaha age column 21 se bada hai aur department column "Science" hai. * ke use se saare columns retrieve hote hain.
The result of the query would be:
Note ke WHERE clause ke use se specified criteria ke basis par rows filter kiye jaate hain. Is example me, sirf wo row retrieve hua jiska age column 21 se bada tha aur department column "Science" tha.
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