Q16 c. 2003 paper (1 Viewer)

[thebigwillie]

Can someone please write the SQL statement for me on here for this question..I'm stumped with this one..Thanx in advance

 

[Freedom_Dragon]

[Cost][Peripheral][Maker][Model]
$99.00..Scanner.....XYZ....xy600z3
$99.00..Scanner...Firefly..600pxt+t

SELECT Cost, Peripheral, Maker, Model
FROM Hardware Table
WHERE Cost="$99.00" AND Peripheral="Scanner"

 

[thebigwillie]

thanx so much dude

 

[konggo]

isnt it

CHOSE maker
FROM HARDWARE : TABLE
WHERE Cost =$99.00 and peripheral=scanner
Order maker By DESC

 

[thebigwillie]

which ones right?

 

[Freedom_Dragon]

The result from the query shows Cost, Peripheral, Maker, Model.
Thus the fields Cost, Peripheral, Maker & Model were SELECTED

 

[konggo]

so its alway

SELECT
FROM
WHERE
ORDER

 

[thebigwillie]

wots ORDER by DESC mean?

 

[konggo]

oder by decending order(alphabetical) or ASED(order by aphabetical assesndin)

 

[Freedom_Dragon]

Ascending Order
Eg: A to Z or 0 to 9
Descending Order
Eg: Z to A or 9 to 0