Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- FEALDATOK:
- create database faallomany character set utf8 collate utf8_hungarian_ci
- create table fa
- SELECT * from fa where telepules like "%Alcsútdoboz%"
- SELECT DISTINCT faj FROM fa WHERE faj like "%tölgy%" ORDER BY;
- Select faj, telepules, kormeret from fa where telepules in("Szeged","Algyő") and kormeret BETWEEN 500 AND 700
- SELECT kormeret, telepules FROM fa;
- Select kormeret, telepules from fa order by kormeret DESC;
- SELECT megye, faj, kormeret from fa, megye WHERE faj='fekete nyárfa' AVG('kormere)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement