SQL functions return a single value. SQL Scalar functions: SQL scalar functions return based on the input value. FORMAT() -- Formats ...
Latest Posts
SQL DROP
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
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
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
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
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
The INNER JOIN selects all record from both tables as there is a match between the columns in both tables. Syntax: SELECT * FROM tab...
Subscribe to:
Posts
(
Atom
)
