Thursday, 7 June 2018

IN Operator

The IN operator allows you to specify multiple values in a WHERE clause.

Syntax :-

   SELECT * FROM table_name
   WHERE column_name IN ('value1' , 'value2' , ......);

Example :-

  SELECT * FROM table_name
  WHERE name IN ('Anu' , 'Sonu');


New table create 



Solve Example :-


Related Posts:

  • OR Operator The OR operator displays a record if either the first condition OR the second condition is true. Syntax :-   SELECT * FROM table_name   W… Read More
  • BETWEEN Number operator The BETWEEN operator selects values within a range. The values can be numbers, text, or dates. 1. Between Number Syntax :-    SELECT * F… Read More
  • ORDER BY This is used to sort the record. ASC - It sorts in ascending order (by default). DESC - It sorts in descending order. 1. Sorts in descending order … Read More
  • LIKE Operator The LIKE operator is used to search for a specified pattern in a column. Syntax :-     SELECT * FROM table_name     W… Read More
  • IN Operator The IN operator allows you to specify multiple values in a WHERE clause. Syntax :-    SELECT * FROM table_name    WHERE column_… Read More

0 Comments:

Post a Comment

Popular Posts

Categories

100 Python Programs for Beginner (96) AI (39) Android (24) AngularJS (1) Api (2) Assembly Language (2) aws (17) Azure (7) BI (10) book (4) Books (197) C (77) C# (12) C++ (83) Course (67) Coursera (249) Cybersecurity (25) Data Analysis (2) Data Analytics (2) data management (11) Data Science (148) Data Strucures (8) Deep Learning (21) Django (16) Downloads (3) edx (2) Engineering (14) Euron (29) Events (6) Excel (13) Factorial (1) Finance (6) flask (3) flutter (1) FPL (17) Generative AI (11) Google (36) Hadoop (3) HTML Quiz (1) HTML&CSS (47) IBM (30) IoT (1) IS (25) Java (93) Java quiz (1) Leet Code (4) Machine Learning (85) Meta (22) MICHIGAN (5) microsoft (4) Nvidia (4) Pandas (4) PHP (20) Projects (29) pyth (1) Python (1034) Python Coding Challenge (454) Python Quiz (113) Python Tips (5) Questions (2) R (70) React (6) Scripting (1) security (3) Selenium Webdriver (4) Software (17) SQL (42) UX Research (1) web application (8) Web development (4) web scraping (2)

Followers

Python Coding for Kids ( Free Demo for Everyone)