SQL- Adding a condition

Question

I am just starting to learn SQL.

How do you add a condition to a statement? I am trying to sort the destination to 'BNA' which is the airport code.

 SELECT 
 CHARTER.CUS_CODE,
 CHARTER.DESTINATION "AIRPORT",
 CHARTER.CHAR_DATE, 
 CHARTER.CHAR_DISTANCE,
 CHARTER.AC_NUMBER,
 FROM C.CHARTER ;

 WHERE DESTINATION = 'BNA' ;

Any hints in the right direction would be great.

Huh? Not clear on your question. If you want sorted output, add an ORDER BY clause. — OldProgrammer
– OldProgrammer, Commented Feb 21, 2014 at 3:31
Well if I just leave the code as "destination", the output would be all the destinations. I just want to sort by one destination and leave out the rest. — TitanC
– TitanC, Commented Feb 21, 2014 at 3:34
When you sort something, your order it. When you leave something out, you filter it. — Brian DeMilia
– Brian DeMilia, Commented Feb 21, 2014 at 3:39
@Chris did you try the sql in my post? The table in the from clause should most likely be "CHARTER" not "C.HARTER" and you need to put the semicolon at the end of the query only. You have a semicolon after the from clause, which is not needed. The semicolon signals the end of a query. — Brian DeMilia
– Brian DeMilia, Commented Feb 21, 2014 at 3:44
There is an extra comma after charter.ac_number (sorry I must have glazed over it before) — Brian DeMilia
– Brian DeMilia, Commented Feb 21, 2014 at 4:22

Brian DeMilia · Accepted Answer · 2014-02-21 04:53:26Z

1

The following is your query with the syntax corrected:

SELECT CHARTER.CUS_CODE,
       CHARTER.DESTINATION "AIRPORT",
       CHARTER.CHAR_DATE,
       CHARTER.CHAR_DISTANCE,
       CHARTER.AC_NUMBER
  FROM CHARTER
 WHERE DESTINATION = 'BNA';

The semicolon goes at the end only.
Get rid of "c." from the table name in your from clause. You might have been thinking of giving it an alias of "c" which, if if that's the case, you would put it after the table name (and then use it as a prefix for each field).

edited Feb 21, 2014 at 4:53

answered Feb 21, 2014 at 3:35

Brian DeMilia

13.3k1 gold badge25 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stuart Ainsworth · Accepted Answer · 2014-02-21 03:35:16Z

1

 SELECT 
 CHARTER.CUS_CODE,
 CHARTER.DESTINATION "AIRPORT",
 CHARTER.CHAR_DATE, 
 CHARTER.CHAR_DISTANCE,
 CHARTER.AC_NUMBER,
 FROM C.CHARTER 
 WHERE DESTINATION = 'BNA' ;

The ; character is a statement terminator; you only need one per SQL statement.

answered Feb 21, 2014 at 3:35

Stuart Ainsworth

12.9k44 silver badges46 bronze badges

Comments

cyan · Accepted Answer · 2014-02-21 03:35:40Z

1

there is ";" at the end of the FROM statement, remove it. and try the sql again. Pay attention with the double quote too on the AIRPORT text.

SELECT CHARTER.DESTINATION + 'AIRPORT ' 
 FROM C.CHARTER
 WHERE DESTINATION = 'BNA' ;

answered Feb 21, 2014 at 3:35

cyan

7475 silver badges8 bronze badges

2 Comments

Brian DeMilia Over a year ago

I think he is just giving that column an alias of "airport", in which case it's fine. He probably doesn't want to concatenate the word "airport" to every destination.

cyan Over a year ago

I see, thanks for the info. I always use "AS" to create Alias.

Collectives™ on Stack Overflow

SQL- Adding a condition

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related