CC SQL 10. creating calculated fields

Card Set Information

Author:
dau108
ID:
146330
Filename:
CC SQL 10. creating calculated fields
Updated:
2012-04-08 03:53:45
Tags:
CC SQL 10 creating calculated fields
Folders:

Description:
CC SQL 10. creating calculated fields
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user dau108 on FreezingBlue Flashcards. What would you like to do?


  1. concatenating fields
    • SELECT Concat(vend_name, ' (', vend_country, ')')
    • FROM vendors
    • ORDER BY vend_name;
  2. using aliases
    • SELECT Concat(vend_name, ' (', vend_country, ')') AS
    • vend_title
    • FROM vendors
    • ORDER BY vend_name;
  3. performing mathamtical calculations
    • SELECT prod_id,
    • quantity,
    • item_price,
    • quantity*item_price AS expanded_price
    • FROM orderitems
    • WHERE order_num = 20005;


    • Operator Description
    • + Addition
    • - Subtraction
    • * Multiplication
    • / Division

What would you like to do?

Home > Flashcards > Print Preview