LArex

Untitled

Aug 11th, 2014
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. Datenbanken:
  2. DISTINCT => Keine doppelten
  3. select DISTINCT s_kunde.plz from s_kunde;
  4.  
  5. Order by <spaltenname> DESC/ASC
  6. select BEZEICHNUNG, NETTOPREIS from s_artikel where nettopreis <50 ORDER By NETTOPREIS DESC;
  7.  
  8. in als ersatz für or
  9. select * from s_kunde where UPPER(s_kunde.ort) = 'KÖLN' or UPPER(s_kunde.ort) = 'LEVERKUSEN';
  10. select * from s_kunde where LOWER(s_kunde.ort) in ( LOWER('KÖLN'),LOWER('LeVerKusen') );
  11.  
  12. substring
  13. select * from s_kunde where upper(substr(s_kunde.name,1,1)) in ('B','C' , 'D');
Advertisement
Add Comment
Please, Sign In to add comment