xxxxxxxxxx
SELECT * FROM products WHERE stock_count <= 10 ORDER BY stock_count ASC;
xxxxxxxxxx
#sql select query
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;
xxxxxxxxxx
-- retrieves all data from a database table
SELECT * FROM Customers
-- retrieves specific columns data from a database table
SELECT Name,Address FROM Customers
-- Kindly upvote this answer if it helped you.
xxxxxxxxxx
Used to select data from a database, which is then returned in a results set.
Example 1: Selects all columns from all users.
SELECT * FROM users;
Example 2: Selects the first_name and surname columns
from all users.xx
SELECT first_name, surname FROM users;
xxxxxxxxxx
Everything in brackets is optional.
SELECT [all/distinct] <COL1>, <COL2>, <COL3>
FROM <TABLE_NAME>
[JOIN <JOIN_CONDITION>]
[WHERE <CONDITION>]
[GROUP BY <COLUMN_NAME>]
[HAVING <SEARCH_CONDITION>]
[ORDER BY <SORT_SPECIFICATION>]
xxxxxxxxxx
SELECT orders.order_id, customers.last_name
FROM orders
INNER JOIN customers
ON orders.customer_id = customers.customer_id
WHERE orders.order_id <> 1
ORDER BY orders.order_id;