Part 8.4 Select clause with where clause in sql in hindi select from where in sql in hindi

Phone no: 9958021083
• Counselling Guruji is our latest product & a well-structured program that answers all your queries related to Career/GATE/NET/PSU’s/Private Sector etc.
You can register for the program at:
You can check out the brochure at:

• Check out our website

• Please spare some time and fill this form so that we can know about you and what you think about us:


• Your review/recommendation and some words can help validating our quality of content and work
so Please do the following: -
1) Give us a 5 star review with comment on Google

2) Follow our Facebook page and give us a 5 star review with comments

3) Follow us on Instagram

4)Follow us on Quora


select clause with where clause,projection and selection operation in relational algebra,select from where s,select from where sql,select from where in a single table,how to write sql query,how to write sql query in database,selcetion operation,projection operation in,projection operation in relational algebra

Select Clause with where clause

• Where clause in SQL is same as ‘σ’ sigma of relational algebra where we specify the conditions/Predicate (horizontal filtering)
• Where clause can have expressions involving the comparison operators. SQL allows us to use the comparison operators to compare strings and arithmetic expressions.
• SQL allows the use of the logical connectives and, or, and not in the where clause.
• SQL includes a between comparison operator to simplify where clauses that specify that a value be less than or equal to some value and greater than or equal to some other value.
• Similarly, we can use the not between comparison operator.


Practice problems on Select clause with where clause

Q Write a SQL query to find all account_no where balance is less the 1000?

Select account_n0
from account
Where balance1000


Q Write a SQL query to find branch name which is situated in Delhi and having assets less than 1,00,000?

Select branch_name
from branch
Where branch_city = ‘Delhi’ and assets 1,00,000

or

Select branch_name
from branch
Where assets 1,00,000 and branch_city = ‘Delhi’

Q Write a SQL query to find branch name and account_no which has balance greater than equal to 1,000 but less than equal to 10,000?

Select branch_name, account_no
from account
Where balance = 1,000 and balance = 10,000

Or

Select branch_name, account_no
from account
Where balance between 1,000 and 10,000

select clause with where clause,projection and selection operation in relational algebra,select from where s,select from where sql,select from where in a single table,how to write sql query,how to write sql query in database,selcetion operation,projection operation in,projection operation in relational algebra,