sql select where in
SELECT * FROM table_name WHERE country IN ('SPAIN', 'MEXICO');
sql select where
SELECT * FROM table_name; -- Sorting col1 ASCending then col2 DESCending SELECT col1, col2 FROM table_name ORDER BY col1 ASC, col2 DESC; -- Filter on col1 SELECT col1, col2 FROM table_name WHERE col1 = 'a value'; -- Containing 'searched' SELECT col1, col2 FROM table_name WHERE col1 LIKE '%searched%'; -- All different values SELECT DISTINCT col1 FROM table_name; -- Simple sum SELECT col1, sum(col2) FROM table_name GROUP BY col1;
sql select
SELECT * FROM TABLE_NAME;
sql where clause
/*using of where clause*/ Select * from customer where customer_id = 1
SQL SELECT WHERE Clause
SELECT * FROM Customers WHERE last_name = 'Doe';