Проектирование и реализация баз данных и клиентских приложений в среде MS Visual Studio.NET. Макурин Ю.Д - 154 стр.

UptoLike

ВУЗ: 

ПГУ | Пенза

Составители: 

Рубрика: 

154
From titles
Where price <> 0
Group By type, pub_id --13 строк
With ROLLUP
V)Объединение таблиц с помощью раздела UNION:
USE Northwind
Select City, Phone Info #Tab1 From customers
Where contacttitle = 'Marketing Assistant'
Select City, Phone Info #Tab 2 From Customers
Where contacttitle = 'Sales Associate'
Selest City, Phone From #Tab1
UNION
Select City, Phone From #Tab2
W)Использование раздела ORDER BY:
USE Northwind
Select ContactTitle, City From Customers
Where ContactTitle IN ('Marketing Assistant'
'Sales Agent'
'Sales Associate')
Order By ContactTitle,City --18 строк
X)Использование раздела COMPUTE:
Select title_id, price From Titles
Where (type = 'bisiness') OR (type = 'mod_cook')
Compute SUM(price), COUNT(price) --6строк и
-- SUM
-- =====
--77.9000
-- CNT
-- =====
-- 6 --всего 7 строк
Select title_id, price From Titles
Where (type = 'business') OR (type = 'mod_cook')
Order By type
Compute Count(price), Sum(Price) By type
Y)Обработка данных с помощью команды UPDATE:
Declare @@Var1 int
SET @@Var1 = 0
Update #TempTableAuthors SET @@Var1 = @@Var1 + 1
Where Contact = 0 
From titles
Where price <> 0
  Group By type, pub_id                  --13 строк
  With ROLLUP

V)Объединение таблиц с помощью раздела UNION:
USE Northwind
Select City, Phone Info #Tab1 From customers
  Where contacttitle = 'Marketing Assistant'
Select City, Phone Info #Tab 2 From Customers
  Where contacttitle = 'Sales Associate'
Selest City, Phone From #Tab1
UNION
Select City, Phone From #Tab2

W)Использование раздела ORDER BY:
USE Northwind
Select ContactTitle, City From Customers
  Where ContactTitle IN ('Marketing Assistant'
                             'Sales Agent'
                             'Sales Associate')
  Order By ContactTitle,City                    --18 строк

X)Использование раздела COMPUTE:
Select title_id, price From Titles
  Where (type = 'bisiness') OR (type = 'mod_cook')
  Compute SUM(price), COUNT(price) --6строк и

                                        -- SUM
                                        -- =====
                                        --77.9000
                                        -- CNT
                                        -- =====
                                        -- 6          --всего 7 строк
Select title_id, price From Titles
  Where (type = 'business') OR (type = 'mod_cook')
  Order By type
  Compute Count(price), Sum(Price) By type

Y)Обработка данных с помощью команды UPDATE:
Declare @@Var1 int
SET @@Var1 = 0
Update #TempTableAuthors SET @@Var1 = @@Var1 + 1
  Where Contact = 0

                                 154

Страницы