select ma.vorname,ma.name from ma
select distinct ma.abt, ma.gehalt from ma
select distinct ma.abt, ma.gehalt from ma order by abt,gehalt
select distinct abt,name,vorname,gehalt from ma where gehalt>90000 order by abt,gehalt desc
select distinct abt,name,vorname,gehalt from ma where gehalt>90000 order by gehalt desc, name,vorname
select abt,vorname,name from ma where abt like 'A%' order by abt,name,vorname
select distinct vorname,name from ma where name rlike 'M[ae][iy]er' order by name,vorname
select distinct vorname,name from ma where name rlike 'Schmi[dt]t*' order by name,vorname
select distinct vorname,name,sex,alter from ma where (sex = 'm' and alter > 63) or (sex = 'w' and alter > 61) order by name,vorname
foreach abt ( `xmsql -h nats13 xamtrup 'select distinct abt from ma'` ) foreach? echo -n $abt foreach? echo -n " " foreach? xmsql -h nats13 xamtrup "select gehalt \ from ma \ where abt = '$abt' \ order by gehalt desc" | head -1 foreach? end
xmsql -h nats13 xamtrup "select abt \ from ma \ order by abt" | uniq -c
Author: | Jan W. Amtrup |
Document: | |
Last modified: |