ClubEnsayos.com - Ensayos de Calidad, Tareas y Monografias
Buscar

Sql Examen


Enviado por   •  10 de Marzo de 2013  •  577 Palabras (3 Páginas)  •  287 Visitas

Página 1 de 3

USE Northwind

GO

SELECT * FROM Customers

GO

select ContactName,PostalCode,Country from Customers--preguta1

select ContactName,PostalCode,Country from Customers--preguta2

where Country in ('Mexico','Francia','spain')--preguta2

select * from Products

select CategoryID,UnitPrice,UnitsInStock from Products--preguta3

select CategoryID,UnitPrice,UnitsInStock from Products--preguta4

where UnitsInStock between 20 and 50--4

select CategoryID,UnitPrice,UnitsInStock from Products--preguta5

where UnitsInStock<20--preguta5

select * from Products

where ProductName like 'M%'--preguta6

select * from Products

where ProductName like '%s%'--preguta7

select*from Employees

select EmployeeID,LastName,FirstName from Employees--preguta8

USE Northwind

GO

SELECT * FROM Customers

GO

select ContactName,PostalCode,Country from Customers--preguta1

select ContactName,PostalCode,Country from Customers--preguta2

where Country in ('Mexico','Francia','spain')--preguta2

select * from Products

select CategoryID,UnitPrice,UnitsInStock from Products--preguta3

select CategoryID,UnitPrice,UnitsInStock from Products--preguta4

where UnitsInStock between 20 and 50--4

select CategoryID,UnitPrice,UnitsInStock from Products--preguta5

where UnitsInStock<20--preguta5

select * from Products

where ProductName like 'M%'--preguta6

select * from Products

where ProductName like '%s%'--preguta7

select*from Employees

select EmployeeID,LastName,FirstName from Employees--preguta8

USE Northwind

GO

SELECT * FROM Customers

GO

select ContactName,PostalCode,Country from Customers--preguta1

select ContactName,PostalCode,Country from Customers--preguta2

where Country in ('Mexico','Francia','spain')--preguta2

select * from Products

select CategoryID,UnitPrice,UnitsInStock from Products--preguta3

select CategoryID,UnitPrice,UnitsInStock from Products--preguta4

where UnitsInStock between 20 and 50--4

select CategoryID,UnitPrice,UnitsInStock from Products--preguta5

where UnitsInStock<20--preguta5

select * from Products

where ProductName like 'M%'--preguta6

select * from Products

where ProductName like '%s%'--preguta7

select*from Employees

select EmployeeID,LastName,FirstName from Employees--preguta8

USE Northwind

GO

SELECT * FROM Customers

GO

select ContactName,PostalCode,Country from Customers--preguta1

select ContactName,PostalCode,Country from Customers--preguta2

where Country in ('Mexico','Francia','spain')--preguta2

select * from Products

select CategoryID,UnitPrice,UnitsInStock from Products--preguta3

select CategoryID,UnitPrice,UnitsInStock from Products--preguta4

where UnitsInStock between 20 and 50--4

select CategoryID,UnitPrice,UnitsInStock from Products--preguta5

where UnitsInStock<20--preguta5

select * from Products

where ProductName like 'M%'--preguta6

select * from Products

where ProductName like '%s%'--preguta7

select*from Employees

select EmployeeID,LastName,FirstName from Employees--preguta8

USE Northwind

GO

SELECT * FROM Customers

GO

select ContactName,PostalCode,Country from Customers--preguta1

select ContactName,PostalCode,Country from Customers--preguta2

where Country in ('Mexico','Francia','spain')--preguta2

select * from Products

select CategoryID,UnitPrice,UnitsInStock from Products--preguta3

select CategoryID,UnitPrice,UnitsInStock from Products--preguta4

where UnitsInStock between 20 and 50--4

select CategoryID,UnitPrice,UnitsInStock from Products--preguta5

where UnitsInStock<20--preguta5

select * from Products

...

Descargar como (para miembros actualizados)  txt (8.7 Kb)  
Leer 2 páginas más »
Leer documento completo Guardar
Disponible sólo en Clubensayos.com