• If there is duplicate result in data but you are asked to show distinct result then command-
  SELECT DISTINCT state FROM customers
   
•  If you are asked to find a list of 10 customers from selected tables and columns then command-
  SELECT id, name FROM customers LIMIT 10
• Use LIMIT to select the id and name columns from customers showing 10 results, starting from the fifth-
  SELECT id, name FROM customers LIMIT 5,10