Welcome Back

Google icon Sign in with Google
OR
I agree to abide by Pharmadaily Terms of Service and its Privacy Policy

Create Account

Google icon Sign up with Google
OR
By signing up, you agree to our Terms of Service and Privacy Policy
Instagram
youtube
Facebook

Select All Records with a Specific Condition in SQL

Select All Records with a Specific Condition in SQL?

Query Explanation:
● SELECT * – Retrieves all columns from the table.
● FROM Customers – Indicates that the data should be fetched from the Customers table.
● WHERE Country = 'India' – Filters the results to include only customers from India.

SQL Query:

SELECT * 
FROM Customers
WHERE Country = 'India';

 

Output: