![]() ![]() We have defined a list of two furniture prices of 2500, 4000, 10000, etc. Now we will demonstrate the use of the PostgreSQL IN operator with numeric values. Illustrate the result of the above statement with the help of the following snapshot.Įxample #3 – The PostgreSQL IN with Numeric Values WHERE furniture_name IN ('Chair', 'Table') Here we find whether any of these furniture names exist in the furniture_name column of the furniture table and returns the matched records of the furniture table as shown below. We have defined a list of two furniture names as ‘Chair’ and ‘Table’. Now we will demonstrate the use of the PostgreSQL IN operator with character or string values. Illustrate the result of the above statement with the help of the following snapshot and the SELECT statement.Įxample #2 – The PostgreSQL IN with Character Values INSERT INTO furniture (furniture_name,furniture_type,furniture_price) Now, insert some data in the furniture table in order to execute SQL statements. Let’s create a table named ‘furniture’ in order to understand the examples: Example #1 – Inserting Data in the Table
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |