Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* Koristeći bazu podataka Northwind napisati upit koji prikazuje listu proizvoda
- i najveću količinu narudžbe za svaki proizvod.*/
- USE NORTHWND
- SELECT [ProductName],
- (SELECT MAX([Quantity])FROM [dbo].[ORDER Details] AS OD WHERE P.ProductID = OD.ProductID )
- FROM [dbo].[Products] AS P
- ORDER BY [ProductName]
- /*Koristeći bazu podataka Northwind prikazati ime kompanije kupca,
- ali samo onih koji su utrošili više od 10 000. */
- SELECT [CompanyName]
- FROM [dbo].[Customers] AS C
- WHERE (SELECT SUM(OD.Quantity*Od.Quantity)
- FROM [dbo].[Orders] AS O JOIN [dbo].[ORDER Details] AS OD ON O.OrderID = OD.OrderID
- WHERE C.CustomerID = O.CustomerID)>10000
- /* Koristeći bazu podataka Northwind prikazati vremensku razliku između pojedinih narudžbi
- i zadnje obavljene naružbe (razliku prikazati u danima). Obavezni format datuma u prikazu: 08.05.2013.*/
- SELECT [OrderID], CONVERT(VARCHAR,[OrderDate],104) AS datum, CONVERT(VARCHAR,(SELECT top 1 [OrderDate] FROM [dbo].[Orders] ORDER BY [OrderDate] DESC),104) AS zadnja,
- datediff(dd,[OrderDate],(SELECT top 1 [OrderDate] FROM [dbo].[Orders] ORDER BY [OrderDate] DESC)) AS razlika
- FROM [dbo].[Orders]
- ORDER BY razlika ASC
- /* Koristeći bazu podataka AdventureWorks2012 prikazati četvrtu najveću platu u preduzeću (po visini primanja).
- Tabela EmployeePayHistory. */
- USE AdventureWorks2014
- SELECT top 1 [Rate]
- FROM (SELECT top 4 [Rate]
- FROM [HumanResources].[EmployeePayHistory]
- ORDER BY [Rate] DESC) AS cetiri
- ORDER BY cetiri.Rate ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement