Results 1 to 5 of 5

Thread: SQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User vladata's Avatar
    Join Date: Dec:2008
    Location:
    Posts: 72

    SQL

    , . 4 , code(primery key), model, speed, ram, hd, cd, price. Laptop code(primery key), model, speed, ram, screen, price. T Product maker, modelcode(primery key), type. Printer code(primery key), model, color, type, price

    :
    1- PC, ram. ( ) - )

    2- , PC - 750 , Laptop- - 750 . maker

    3- , PC - RAM - PC, - RAM. maker.

    4- PC, , . maker, HD.


  2. #2
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    Quote Originally Posted by vladata View Post
    " "? ?
    ''? * *
    - !
    ...

  3. #3
    Registered User vladata's Avatar
    Join Date: Dec:2008
    Location:
    Posts: 72
    , . 9, 5.

    1-
    SELECT * FROM Product
    WHERE type=Printer

    2- ( ), B ( )
    SELECT code price FROM PC Laptop Printer
    (SELECT * FROM Product WHERE maker LIKE 'B%')

    3- PC
    SELECT AVG(speed) FROM PC

    4- , - . model
    SELECT model FROM Product
    (SELECT MAX(PC.price Laptop.price Printer.price)

    5- PC Laptop-, . (. )
    SELECT AVG(PC.price Laptop.price) FROM Product
    WHERE model LIKE 'A%')

  4. #4
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    ''? * *
    - !
    ...

  5. #5
    Registered User vladata's Avatar
    Join Date: Dec:2008
    Location:
    Posts: 72
    ,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |