dzienniktostera

[dzienniktostera]

https://www.essentialsql.com/what-is-the-difference-between-a-right-and-left-outer-join/

The difference between left and right outer joins has to do with table position.  A left and right refer to where a table resides in relationship to the FROM clause.  The left table is the table that is in the FROM clause, or left of the join condition, the join clause here.  And a right table is on the right side of the join clause.

[dzienniktostera]

dog test api

[dzienniktostera]

cltr + alt + c OR cmd + altc + c

[dzienniktostera]

Postman tutorials

https://www.toolsqa.com/postman/postman-navigation/

https://www.guru99.com/postman-tutorial.html

https://blog.postman.com/2016/11/09/generate-spotify-playlists-using-a-postman-collection/

https://learning.postman.com/docs/postman/collection-runs/newman-with-docker/

https://docs.postman-echo.com/?version=latest

[dzienniktostera]

https://www.w3schools.com/quiztest/quiztest.asp?qtest=SQL

Question 12:

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'    Your answer  SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'    Correct answer  SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

[dzienniktostera]

testdome sql examples UNION

Information about pets is kept in two separate tables:

TABLE dogs  id INTEGER NOT NULL PRIMARY KEY,  name VARCHAR(50) NOT NULL TABLE cats  id INTEGER NOT NULL PRIMARY KEY,  name VARCHAR(50) NOT NULL

Write a query that select all distinct pet names.

-- Write only the SQL statement that solves the problem and nothing else.

SELECT DISTINCT dogs.name FROM dogs UNION SELECT DISTINCT cats.name FROM cats;

The SQL UNION Operator

The UNION operator is used to combine the result-set of two or more SELECT statements.

Each SELECT statement within UNION must have the same number of columns

The columns must also have similar data types

The columns in each SELECT statement must also be in the same order

UNION SyntaxSELECT column_name(s) FROM table1

UNION

SELECT column_name(s) FROM table2;UNION ALL Syntax

The UNION operator selects only distinct values by default. To allow duplicate values, use UNION ALL:

SELECT column_name(s) FROM table1

UNION ALL

SELECT column_name(s) FROM table2;

Note: The column names in the result-set are usually equal to the column names in the first SELECT statement in the UNION.

https://www.w3schools.com/sql/sql_union.asp