SQL functions return a single value. SQL Scalar functions: SQL scalar functions return based on the input value. FORMAT() -- Formats ...
Home Archives for December 2016
SQL DROP
December 10, 2016
0
The DROP INDEX command is used to delete an index in a table. Syntax: DROP INDEX table_name.index_name Drop Table The DROP Table co...
SQLCROSS JOIN
December 10, 2016
0
Cross join does not combine the rows, if you have 8 rows in table_1 and 5 rows in table_2 in each table with 1 to 1 match, you get 40 resul...
SQL FULL OUTER JOIN
December 10, 2016
0
The FULL OUTER JOIN returns all(both LEFT and RIGHT joins.) record from the left table (table_1) and from the right table (table_2). S...
SQL RIGHT JOIN
December 10, 2016
0
The RIGHT JOIN returns all record from the right table (table_2), with the matching record in the left table (table_1). The result is NULL ...
SQL LEFT JOIN
December 10, 2016
0
The LEFT JOIN returns all record from the left table (table_1), with the matching record in the right table (table_2). The result is NULL i...
SQL INNER JOIN
December 10, 2016
0
The INNER JOIN selects all record from both tables as there is a match between the columns in both tables. Syntax: SELECT * FROM tab...
SQL Joins
December 10, 2016
0
SQL joins are used to combine rows from two or more tables. When a query includes more than one table, you need to specify how records...
SQL BETWEEN Operator
December 10, 2016
0
The BETWEEN operator is used to select values within a particular range. Syntax: SELECT * FROM table_name WHERE column_some_name BE...
SQL IN Operator
December 10, 2016
0
The IN operator allows you to specifies multiple values in a WHERE clause. Syntax: SELECT * FROM table_name WHERE column_some_name...
SQL LIKE Operator
December 10, 2016
0
The LIKE operator is used in a WHERE clause to search for a specified pattern record in a column. The "%" sign is used to define...
SQL SELECT TOP Clause
December 10, 2016
0
The SELECT TOP clause is used to specify the number of records to return. Syntax: SELECT TOP number column_name,.... FROM table_name...
SQL DELETE Command
December 10, 2016
0
The DELETE command is used to delete records in a table. Syntax: Delete specifies which record or records that should be deleted. DEL...
SQL UPDATE command
December 10, 2016
0
The UPDATE command is used to update existing records in a table. Syntax: without a where clause The WHERE clause specifies which reco...
SQL INSERT INTO Command
December 10, 2016
0
The INSERT INTO comman is used to insert new records in a table. SQL INSERT INTO Syntax: INSERT INTO table_name (column_1_name,column...
SQL ORDER BY Keyword
December 10, 2016
0
If you want the data to appear in a specific order you need to use the “order by” keyword. Syntax: SELECT column_1_name, column_2_nam...
SQL AND & OR Operators
December 10, 2016
0
The AND & OR operators are used to filter records to find more than one condition. AND Operator syntax: SELECT * FROM table_name...
Subscribe to:
Posts
(
Atom
)
