Students helping students, join us in improving Bored of Studies by donating and supporting future students!
I don't know... I've always thought SELECT to be select every single field you'll never need in the search criteria/query because you'll need to find the source somehow, directly linking and 'selecting' the field names beforehand, so that you can always look at the FROM TABLE line to figure out where to get such fields.Originally posted by Jeo
SELECT means you want to display it. SELECT state is useless, and its not right actually.
You can do WHERE state = nsw without SELECT state
When I said display, I meant SELECT, sorry.
"Draw a Gantt chart to show how the tasks can be completed in the minimum amount of weeks"Originally posted by Huy
You're right.
This can occur at the same time as software installation and system testing (the task above, reference number 4).
You can have 10 weeks, thank you for that gmraso!
yep thats what you do... you dont have to specify "suburb" because you are NOT selecting it to be displayed...Originally posted by Huy
Question:
If I wanted to search for every friend living in Parramatta, would I have:
SELECT Last_name, First_name
FROM FRIENDS
WHERE Suburb="Parramatta"
ORDER BY Last_name ASC
(for example)
Even though you have not indicated explicitly that the field name "Suburb" was to be selected?
You got meOriginally posted by FadeToBlack
"Draw a Gantt chart to show how the tasks can be completed in the minimum amount of weeks"
Thanks for clarifying DazedOriginally posted by *~Dazed~*
yep thats what you do... you dont have to specify "suburb" because you are NOT selecting it to be displayed...
but i doubt you will lose marks for that one mistake because im sure that the criteria doesnt account for it... as long as you have all the othershit require i doubt that is worth losing a mark over
Hopefully not... but it should correctly read:Originally posted by boredofschool
do I lose marks if I wrote:
ORDER BY Last_name Ascending
Rectangles have to be connected to each other? YesOriginally posted by *hopeful*
hey in a gannt chart do the rectangles have to be connected to each other? i got 9 weeks
omg i did my user input screen in pen and i only drew a big box in pencil, is dat like totally wrong?