Share
Showing posts with label BETWEEN. Show all posts
Showing posts with label BETWEEN. Show all posts


  • Select a row from a specific column by giving a condition-
    SELECT name, address FROM customers WHERE id=54
  • Select all the row accept a specific row from a column-
    SELECT name, address FROM customers WHERE id !=54
  • Select rows by implementing different condition-
    SELECT name, address FROM customers WHERE id <54
  • Select  rows between two specific rows by using statement BETWEEN-
    SELECT name, state FROM customers WHERE id BETWEEN 20 AND 30