SQL Help please?? [Archive]

over clocker

05-14-02, 15:03

Hiya guys, Our uni LMS server is down so I cant get to my notes for my revision

I need to "describe the 6 clauses on the syntax of an SQL query, and describe the purpose of each of the 6 clauses. Which of the 6 clauses is required and which is optional?"

It is a question of a past paper I am using for my revision.

If anyone could help or point me in right direction, I wud be most appreciative!!

Mal

c.ravi

05-30-02, 05:05

hello,

may be ur asking for

select
from
where
group by
having
order by

the last four r optional.

hope this helps u