SQL IN, BETWEEN & LIKE Operators Explained 💻 | Easy Examples for Beginners

Описание: “Learn SQL IN, BETWEEN & LIKE Operators with simple and easy examples in Hindi.

Follow the "SQL Programming" channel on WhatsApp: https://whatsapp.com/channel/0029VbB6...

In this video, you will learn:

✅ How to use IN operator to select multiple specific values
✅ How to use BETWEEN operator for range selection
✅ How to use LIKE operator for pattern matching

This video is perfect for BCA, MCA, B.Tech students, and SQL beginners.
Watch till the end to master these three SQL operators and make your queries powerful!

📌 Don’t forget to like, comment, and subscribe to The Surya Academy for more SQL tutorials in Hindi.
🔔 Hit the bell icon to never miss new videos!”

-- create
CREATE TABLE Books (
book_id INT PRIMARY KEY,
title VARCHAR(50),
author VARCHAR(30),
subject VARCHAR(20),
price DECIMAL(6,2),
publication_year INT
);


INSERT INTO Books (book_id, title, author, subject, price, publication_year) VALUES
(1, 'The SQL Story', 'John Deo', 'Database', 499.00, 2018),
(2, 'Learn Python Fast', 'Anita Rao', 'Programming', 599.00, 2020),
(3, 'Magic of Math', 'Ravi Patel', 'Maths', 299.00, 2016),
(4, 'World of Science', 'Nina Sharma', 'Science', 699.00, 2019),
(5, 'English Grammar Pro', 'S. Mehta', 'English', 399.00, 2015),
(6, 'SQL Secrets', 'John Deo', 'Database', 450.00, 2021),
(7, 'Story of AI', 'Vikram Gill', 'Technology', 550.00, 2022);

-- fetch
SELECT * FROM Books;

-- Find all books that have the word “Story” in their title?
SELECT * FROM Books
WHERE title LIKE '%Story';
-- Find all books where the subject is either Science, Maths, or English?
SELECT * FROM books
WHERE subject IN ('Database','Maths','English');
-- Find all books published between 2016 and 2020?
SELECT * FROM Books
WHERE publication_year between 2016 and 2020;

#SQL #INOperator #BETWEENOperator #LIKEOperator #SQLTutorial #LearnSQL #SQLforBeginners #TheSuryaAcademy #Database #SQLQuery #SQLHindi #SQLExamples #DatabaseManagement