SQL Server Course for Beginners with 100+ examples - WHERE Clause in SQL

The video tutorial explains how to use SQL queries to fetch records from a database based on specific conditions. It covers the use of the WHERE clause to filter records by salary and employee name, and demonstrates how to modify queries to display complete records. The tutorial also explores advanced conditions using greater than or equal to operators to fetch records of employees with salaries above a certain threshold.

What is the purpose of the WHERE clause in SQL?

• To join two tables

• To filter records based on a condition

• To sort records in a table

• To delete records from a table

Which SQL command is used to view all records in a table?

• UPDATE table_name

• DELETE FROM table_name

• INSERT INTO table_name

• SELECT * FROM table_name

How can you display only the employee names with a salary of 8000?

• SELECT * FROM employee WHERE salary = 8000

• SELECT city FROM employee WHERE salary = 8000

• SELECT EMP name FROM employee WHERE salary = 8000

• SELECT salary FROM employee WHERE EMP name = 'Emma'

What should be added to a string condition in SQL?

• Quotes

• Semicolons

• Parentheses

• Brackets

Which employees will be displayed with the condition 'salary >= 7000'?

• Only those with a salary of 7000

• Employees with a salary less than 7000

• Employees with a salary greater than or equal to 7000

• All employees