Advertisement
halexandru11

25 BD

Dec 22nd, 2020
95
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT NUME, TITLU, DOMENIU FROM ABONAMENTE
  2. INNER JOIN PUBLICATII ON PUBLICATII.ID = ABONAMENTE.IDP
  3. WHERE UPPER(DOMENIU) LIKE 'IT%'
  4. ORDER BY NUME
  5.  
  6. SELECT DISTINCT TITLU, DOMENIU, PRET, PRET*1.19 AS "PRET CU TVA" FROM PUBLICATII
  7. LEFT OUTER JOIN ABONAMENTE ON PUBLICATII.ID = ABONAMENTE.IDP
  8.  
Advertisement
RAW Paste Data Copied
Advertisement