'Write css selector to the below

  1. <h2> welcome to the application</h2>
  2. If two elements has same class name and there is no other attribute,then how to write css selector using the text write css for these 2 examples
css-selectorssqlon-duplicate-key


Solution 1:[1]

A MERGE INTO is standard Sql.
But it seems that upserts are not supported by techonthenet

MERGE INTO customers tgt
USING (
  SELECT 
    4000 AS customer_id,
    'new last name' AS last_name, 
    'new first name' AS first_name
) src ON (src.customer_id = tgt.customer_id)
WHEN MATCHED THEN
    UPDATE SET last_name = src.last_name
             , first_name = src.first_name
WHEN NOT MATCHED THEN
    INSERT (customer_id, last_name, first_name) 
    VALUES (src.customer_id, src.last_name, src.first_name)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions