var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Quick Query question
Im stuck making my queries.........
I have an airport table, with, AIRPORTID, CITY, COUNTRY, RUNWAYCOUNT.
I have to write a query which will display the cities for where the number of runways is not know,
This is what ive got so far.
Where numberofrunways = ‘’
Thanks in advance
you schould make:
Where numberofrunways is null;
Thanks, was almost there lol i am learning and this forum is teaching me so much! Instant replys almost.
The types of flights leaving London is another query im not sure on
Table is called Aircraft:
Where DepartAirport = 'London';
Or would that be like "is Null" and say "is London"
Use "=" for values (like 'London' or 3.14159) and "is" (or "is not") just for nulls.
For "not equals" you are spoilt for choice: "!=", "<>", "^=".
Ahhhhh right i see, thanks for that
Do you think my aircraft Query is correct??
You could add a DISTINCT in order not to get duplicate FlightType values :
(And BTW, no comma after FlightType and Aircraft
Where DepartAirport = 'London'; )
Haha, thanks, put both of them in now. I had forgot commas on a few other queries as well
what a noob!
Becareful with the DISTINCT clause
Use the DISTINCT clause only if it is extremely necessary.
This clause increase the cost on the database, especifically if the table is full of data.
Just a pointer for you for later on - whatever you put in quotes must match exactly what's on the table e.g. "...where DepartAirport = 'London'..." will not return records where the departure airport is on the database as 'LONDON', 'london' etc
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.
thanks for that tip!