<html>
<head>
<title>Sequel Pro Help - SQL Query Examples</title>
<meta name="AppleTitle" content="SQL Query Examples">
<meta name="AppleFont" content="Lucida Grande">
<meta ROBOTS="robots" CONTENT="anchors">
</head>
<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">

<font face="Lucida Grande,Geneva,Arial">

<br>

<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
	<tr>
		<td align="left" valign="top" width="70">
		<img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
		</td>
		<td align="left"><h1>SQL Query Examples</h1>
		</td>
	</tr>
	<tr>
		<td colspan="2">
		<img src="bar.gif" width="100%" height="20">
		</td>
	</tr>
</table>

<br>
<font size="-1">
&nbsp;<a href="../index.html">Back to the main menu</a>
<br>
<br>
<table border="0" width="95%">
	<tr>
		<td>
		<font face="Lucida Grande,Geneva,Arial" size="-1">
		The following queries are only examples and any use of these queries in a company or critical environment
		signifies the prior knowledge and acceptance, on behalf of the implentor, that the authors of this software are not liable for damages or losses in use of these queries.
		No guarantees are made as to the quality or reliabity of the queries listed below. They are listed to help database designers/creators in their
		work by showing an example.
		</font>
		</td>
	</tr>
</table>
<br>
<br>
<table border="0" cellpadding="5" cellspacing="10" width="100%" align="center">
	<tr>
		<td valign="top" bgcolor="#EAEAEA">
		<font face="Lucida Grande,Geneva,Arial" size="-1">
		<b>Example SELECT Query</b>
		<hr>
		This obtains information an account table and only returns the accounts with logins of 1 or more,
		ordered alphabetically by the person's name.
		<br>
		<br>
		<b>SELECT * FROM accounts WHERE LoginCount > 1 ORDER BY Name</b>
		<br>
		</font>
		</td>
	</tr>
	<tr>
		<td valign="top" bgcolor="#EAEAEA">
		<font face="Lucida Grande,Geneva,Arial" size="-1">
		<b>Example DELETE Query</b>
		<hr>
		This query deletes one row of data from a product table.
		<br>
		<br>
		<b>DELETE FROM products WHERE ProductID=5 LIMIT 1</b>
		<br>
		</font>
		</td>
	</tr>
</table>

</font>

</body>
</html>