This repository has been archived by the owner on Jul 24, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
common-sql-queries.html
15 lines (15 loc) · 1.96 KB
/
common-sql-queries.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
<!doctype html><html lang="en"><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1"><meta http-equiv="X-UA-Compatible" content="ie=edge"><meta name="description" content="These are some common SQL queries that come up."><!-- Bing --><meta name="msvalidate.01" content="45CBBE1BD8265A2217DFDA630EB8F84A" /><title>Tiny Brain Fans - Common SQL Queries</title><link rel="stylesheet" href="tinystyle.css"></head><body>
<main id="main"><article id="content"><h1 id="title">Common SQL Queries</h1><p>These are some common <a href="sql.html">SQL</a> queries that come up. All <code>?</code> symbols represent a place where you would dynamically insert info, like with Node's <a href="mysql.html">MySQL</a> module.</p>
<h2>Retrieval</h2>
<p>Get the info from all rows with a given email</p>
<pre><code class="language-mysql">SELECT * FROM example_table
WHERE email = ?;
</code></pre>
<p><a href="https://learnsql.com/blog/how-to-find-duplicate-values-in-sql/" target="_blank" title="Finding duplicate values in SQL">See if more than one entry exists with a given email</a></p>
<pre><code class="language-mysql">SELECT email, COUNT(email)
FROM example_table
GROUP BY email
HAVING COUNT(email) > 1;
</code></pre>
<h2>References</h2>
<section id="backlinks"><details><summary>Backlinks</summary><ul><li><a href="sql.html">SQL</a></li></ul></details></section><p class="last-modified">Last modified: 202206101419</p></article></main><footer><nav><a href="index.html">Sitemap</a></nav><div class="social"><p>Built using <a href="http://codeberg.org/milofultz/swiki" target="_blank" rel="noopener noreferrer">{{SWIKI}}</a></p><p><a href="http://codeberg.org/milofultz/" target="_blank" rel="noopener noreferrer">Codeberg</a></p><p><a href="http://milofultz.com/" target="_blank" rel="noopener noreferrer">milofultz.com</a></p><p><a href="https://merveilles.town/@milofultz" target="_blank" rel="me noopener noreferrer">Mastodon</a></p></div></footer></body></html>