More Help with 2006 paper (1 Viewer)

[Niksta123]

Can some one help me out on:

How to construct an SQL command from the HSC IPT 2006 paper Qu 21 (A)

thanks

 

[peter19]

Can some one help me out on:

How to construct an SQL command from the HSC IPT 2006 paper Qu 21 (A)

thanks

I know the answer to that question but im not going to tell you. Simply because im bitter and mean.

 

[Niksta123]

I've had a go at it...can some1 tell me if this is correct or if not what is wrong with it..


SELECT CountryName
FROM 'Countries'
WHERE Continent = 'South America' AND Language = 'Spanish'

 

[jwkhan]

hello...
lol lemme have a look at the question

 

[MathsIsWeird]

Im pretty sure thats right Niksta, i did that paper about 6 months ago its about the only thing i can remember from IPT, but just wait for someone else to check because i lost the paper lol.

 

[Starcraftmazter]

SELECT CountryName
FROM 'Countries'
WHERE Continent = 'South America' AND Language = 'Spanish'

Almost right, you don't need single quotes around the table countries, since it's an internal entity of the database.

So would be like this:

SELECT CountryName FROM Countries WHERE Continent = 'South America' AND Language = 'Spanish';

Don't mind the semicolon, that's just how I do my mysql queries.