Database Queries! (1 Viewer)

[renegades@stgc]

Any & All Database Questions

 

[fatmuscle]

yes?

What about database queries?

do you need help or would like to offer help?

 

[priesty]

yes?

What about database queries?

do you need help or would like to offer help?

yeh wat he said... :s

 

[...]

Select ... From ... Where ...

 

[redslert]

SELECT questions
FROM users
WHERE username = 'renegades@stgc';

 

[ari89]

Structure Query Language

SELECT <fields>
FROM <table>
WHERE criteria eg name='da vinci'
ORDER BY order eg ascending

 

[JoAn.T]

Please click one of the Quick Reply icons in the posts above to activate Quick Reply.

 

[JoAn.T]

SQL... argh... I'm having a pract exam without computers nxt weeek on database... and apparantly one of the thingios we'll be tested is wirting a SQL.

How come the SQL you guys use are so simple compared to the SQL provided and created with microsoft access?

Thanks for the hint with the simple SQL though! Greatly appreciated!

 

[Lwaxana]

The examples you have been given are in the format the examiners will expect in the HSC - the syllabus doesnt say anything about teaching Access, or Word or Excel for that matter ( just those forms of software) and so you can not be expected to answer in the same syntax as Access.
Just remember
Structured Queried Language (SQL) is a query language used to access and manage data in a relational database.

SELECT field eg LastName
FROM table eg Customer
WHERE criteria eg LastName = “Smith”
ORDER BY display eg LastName DESC

Ascending order is default ie. if not stated use ascending
Fields are separated by commas
Entity and its attribute separated by full stop
Search criteria enclosed in double quotes

 

[Lwaxana]

Many thanks

its always helpful to see how the topic is handled at Uni level
so I can atleast introduce terms at HSC levels

any thing else you have to share with a poor old teacher ??

 

[...]

2nd year database course from MQ:

http://www.comp.mq.edu.au/units/comp224/2005/Lectures/index.html