SQL SELECT WHERE
snippet in sql

sql select syntax

user4516

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>]


/*
Specifically for SQL -> Oracle

LEGEND: 
[...]   :   optional entries
<...>   :   your specific entry
*/

sql select

user8111

SELECT * FROM TABLE_NAME;

SQL SELECT WHERE

user2608

SELECT column1, column2, ...
FROM table_name
WHERE condition; 

select query in sql

user284

SELECT column_name FROM table_name;

SELECt sql

user2687


SELECT column1, column2, ...

FROM table_name; 

where query in sql server

user1762

SELECT * FROM Customers
WHERE Country='Mexico';