2/12/2024 0 Comments Sqlite for windowsThe CASE statement is similar to the IF-THEN-ELSE statement. If no conditions are true, it will return the value in the ELSE clause. As it fulfills the first condition, it will stop reading the condition and return the result. 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 |