Help for this page

Select Code to Download


  1. or download this
    item1  perl
item2  python
item3  ruby
item4  php"
  2. or download this
    SELECT concat('item1 ', item1) FROM basket WHERE item LIKE 'a%'
 UNION 
SELECT concat('item2 ', item2) FROM basket WHERE item2 LIKE 'a%'
 ORDER BY 1
  3. or download this
    SELECT 'item1 ' || item1 FROM basket WHERE item LIKE 'a%'
 UNION 
SELECT 'item2 ' || item2 FROM basket WHERE item2 LIKE 'a%'
 ORDER BY 1