24 December 2020

Filter

  • Where – filter rows based on a specified condition.
  • Limit – get a subset of rows generated by a query.
  • Fetch– limit the number of rows returned by a query.
  • In – select data that matches any value in a list of values.
  • Between – select data that is a range of values.
  • Like – filter data based on pattern matching.
  • Is Null – check if a value is null or not.

No comments:

Post a Comment

Most views on this month