Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. FEALDATOK:
  2. create database faallomany character set utf8 collate utf8_hungarian_ci
  3. create table fa
  4. SELECT * from fa where telepules like "%Alcsútdoboz%"
  5. SELECT DISTINCT faj FROM fa WHERE faj like "%tölgy%" ORDER BY;
  6. Select faj, telepules, kormeret from fa where telepules in("Szeged","Algyő") and kormeret BETWEEN 500 AND 700
  7. SELECT kormeret, telepules FROM fa;
  8. Select kormeret, telepules from fa order by kormeret DESC;
  9. SELECT megye, faj, kormeret from fa, megye WHERE faj='fekete nyárfa' AVG('kormere)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement