PPT Slide

Izgledalo bi bolje da smo kucali ORDER BY:

select s.studentid, s.studentname, sc.classid

from student s, stud_class sc

where s.studentid = sc.studentid

order by s.studentname, sc.classid;

ID STUDENTNAME CLASSID

--- ------------------------------ ------------

1 Svjetlana Djuric 4

3 Tomic Marija 3

6 Vladimir Babic 2

6 Vladimir Babic 1

6 Vladimir Babic 3

Previous slide

Next slide

Back to first slide

View graphic version