cheatsheet for sql
Guys, are you looking for SQL cheatsheet, in pdf format :)
-> https://buggyprogrammer.com/sql-cheatsheet/cheatsheet for sql
Guys, are you looking for SQL cheatsheet, in pdf format :)
-> https://buggyprogrammer.com/sql-cheatsheet/sql cheat sheet
# Finding Data Queries
# SELECT: used to select data from a database
SELECT * FROM table_name;
# DISTINCT: filters away duplicate values and returns rows of specified column
SELECT DISTINCT column_name;
# WHERE: used to filter records/rows
SELECT column1, column2 FROM table_name WHERE condition;
SELECT * FROM table_name WHERE condition1 AND condition2;
SELECT * FROM table_name WHERE condition1 OR condition2;
SELECT * FROM table_name WHERE NOT condition;
SELECT * FROM table_name WHERE condition1 AND (condition2 OR condition3);
SELECT * FROM table_name WHERE EXISTS (SELECT column_name FROM table_name WHERE condition);
# ORDER BY: used to sort the result-set in ascending or descending order
SELECT * FROM table_name ORDER BY column;
SELECT * FROM table_name ORDER BY column DESC;
SELECT * FROM table_name ORDER BY column1 ASC, column2 DESC;
SELECT TOP: used to specify the number of records to return from top of table
SELECT TOP number columns_names FROM table_name WHERE condition;
SELECT TOP percent columns_names FROM table_name WHERE condition;
# Not all database systems support SELECT TOP. The MySQL equivalent is the LIMIT clause
SELECT column_names FROM table_name LIMIT offset, count;
# LIKE: operator used in a WHERE clause to search for a specific pattern in a column
# % (percent sign) is a wildcard character that represents zero, one, or multiple characters
# _ (underscore) is a wildcard character that represents a single character
SELECT column_names FROM table_name WHERE column_name LIKE pattern;
LIKE ‘a%’ # (find any values that start with “a”)
LIKE ‘%a’ # (find any values that end with “a”)
LIKE ‘%or%’ # (find any values that have “or” in any position)
LIKE ‘_r%’ # (find any values that have “r” in the second position)
LIKE ‘a_%_%’ # (find any values that start with “a” and are at least 3 characters in length)
LIKE ‘[a-c]%’ # (find any values starting with “a”, “b”, or “c”
# See more in the source linklinq cheat sheet
Dim query = from m in Manufacturers
where m.Name = "Trek"
select new with {.Name = m.Name, .ManufacturerId = m.ManufacturerId}
Dim lambda = Manufacturers.Where(function(m) m.Name = "Trek").Select(function(m) new with {.Name = m.Name, .ManufacturerId = m.ManufacturerId})Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
