Results 1 to 5 of 5
Thread: SQL
Hybrid View
-
6th June 2009 16:41 #1
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.
-
6th June 2009 18:09 #2
-
6th June 2009 18:44 #3
, . 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%')
-
6th June 2009 20:43 #4
SQL JOIN ( : http://www.w3schools.com/Sql/sql_join.asp), .
''? * *
- !
...
-
6th June 2009 21:15 #5




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in