Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Datenbanken:
- DISTINCT => Keine doppelten
- select DISTINCT s_kunde.plz from s_kunde;
- Order by <spaltenname> DESC/ASC
- select BEZEICHNUNG, NETTOPREIS from s_artikel where nettopreis <50 ORDER By NETTOPREIS DESC;
- in als ersatz für or
- select * from s_kunde where UPPER(s_kunde.ort) = 'KÖLN' or UPPER(s_kunde.ort) = 'LEVERKUSEN';
- select * from s_kunde where LOWER(s_kunde.ort) in ( LOWER('KÖLN'),LOWER('LeVerKusen') );
- substring
- 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