![]() The SQLite CASE expression evaluates through conditions and fetches a value when it fulfills the first condition. The above query returns the students whose age is between 20 years and 30 years. WHERE column_name BETWEEN value1 AND value2 It has both the starting and the ending values included. The BETWEEN operator selects values within a given range. The above query returns unique address values from the table. It is used when you have many duplicate values in the table. The DISTINCT clause with the SELECT statement is used to return only distinct records.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |