SELECT ALL Query using IN

[FooKelvin]

Can i have select all query inside the IN statement?

WHERE Name in()   // Select all data in bracket

[benanamen]

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

 

SQL IN Syntax

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

 

Example

SELECT * FROM Customers
WHERE City IN ('Paris','London');

[Barand]

The simple answer is "No".

 

If you want to select all, don't specify the IN() condition