Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table oseba(
- id number(2),
- ime varchar(30),
- priimek varchar(30),
- starost number(3)
- );
- insert into oseba(id,ime,priimek,starost)
- values(1,'Marko','Arni�',18);
- insert into oseba(id,ime,priimek,starost)
- values(2,'Barbara','Bolha',19);
- insert into oseba(id,ime,priimek,starost)
- values(3,'Ale�','De�man',20);
- insert into oseba(id,ime,priimek,starost)
- values(4,'Teja','Kralj',22);
- insert into oseba(id,ime,priimek,starost)
- values(5,'Leon','Luznar',17);
- select ime
- from oseba;
- select ime, priimek, starost
- from oseba
- where ime like 'M%';
- select ime, priimek, starost
- from oseba
- where ime like 'M%o';
- select ime, priimek, starost
- from oseba
- where ime like 'M%' or ime like 'B%';
- select ime, priimek, starost
- from oseba
- where ime like 'M%' and priimek like 'A%';
- select ime, priimek, starost
- from oseba
- where ime like '%l%';
- select ime, priimek, starost
- from oseba
- where ime like '%arb%';
- select ime, priimek, starost
- from oseba
- where ime like '_a%';
- select ime, priimek
- from oseba
- where ime like '%o_';
- select ime, priimek
- from oseba
- where ime like '_a%' and ime like '%k_';
- select starost, ime, priimek
- from oseba
- where starost>18;
- select starost, ime, priimek
- from oseba
- where starost<18;
- select starost, ime, priimek
- from oseba
- where starost>18 and starost<25;
- select starost, ime, priimek
- from oseba
- where starost between 18 and 25;
- select starost, ime, priimek
- from oseba
- where starost between 18 and 25 and ime like'A%';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement