changeset 159:b698eaa97041

Fixed grammar.
author Oleksandr Gavenko <gavenkoa@gmail.com>
date Tue, 30 Oct 2018 20:13:44 +0200
parents 4f778e7d5852
children 86f16efac74f
files a05353a8-e088-11e6-a39b-485b39c42d0f/index.rst
diffstat 1 files changed, 6 insertions(+), 5 deletions(-) [+]
line wrap: on
line diff
--- a/a05353a8-e088-11e6-a39b-485b39c42d0f/index.rst	Tue Oct 30 20:07:23 2018 +0200
+++ b/a05353a8-e088-11e6-a39b-485b39c42d0f/index.rst	Tue Oct 30 20:13:44 2018 +0200
@@ -9,10 +9,10 @@
 .. contents::
    :local:
 
-There are a lot of questions in DB and SQL topic. I put here some simple and tricky one.
+There are a lot of questions in DB and SQL topic. I put here some simple and tricky ones.
 
-What difference between the WHERE and HAVING clauses?
-=====================================================
+What is the difference between the WHERE and HAVING clauses?
+============================================================
 
 When ``GROUP BY`` is not used, the ``WHERE`` and ``HAVING`` clauses are essentially equivalent.
 
@@ -22,7 +22,7 @@
   groupings are made.
 * The ``HAVING`` clause is used to filter values from a group.
 
-What is a key difference between Truncate and Delete?
+What is a key difference between TRUNCATE and DELETE?
 =====================================================
 
 ``TRUNCATE`` is DDL (Data Definition Language) command and so cannot be rolled back. It deletes all
@@ -74,7 +74,8 @@
 
   SELECT name FROM customers WHERE patent <> 2 OR patent in NULL;
 
-Also ``NOT IN`` always ``FALSE`` if sub-table have ``NULL``. This query may result in empty result::
+Also ``NOT IN`` always ``FALSE`` if sub-table has ``NULL``. This query may be resolved in empty
+result::
 
   SELECT * FROM customers WHERE id NOT IN (SELECT customer_id FROM orders)