select * from customers where Country='Canada' or Country='Germany'
select * from employees where TitleofCourtesy = 'Ms.' or TitleofCourtesy='Mrs.'
select * from employees where TitleofCourtesy = 'Ms.' or TitleofCourtesy='Mrs.'
and Title='Sales Representative'
select * from employees where Title=' Sales Representative' and TitleofCourtesy='Ms.' or TitleofCourtesy='Mrs.'
select * from customers Where Contacttitle like '%Manager%'
select * from customers where Phone is NULL or Fax is NULL
select * from customers where region is not NULL
select * from products where UnitPrice >10 and UnitPrice<90
select * from products where UnitPrice BETWEEN 10 AND 90 order by UnitPrice DESC
select * from Orders where OrderDate Between '2/6/1997' AND '3/11/1998' order by Orderdate desc
FAQ
Types of Application Software?
16/12/2009 12:28———
Tron(OS) - one of the most widely use OS
13/11/2009 10:47———
list of Blog Sites
13/11/2009 10:36———
Types of Website
13/11/2009 10:31———
Topic: FAQ
———
select * from customers where Country='Canada' or Country='Germany'
select * from employees where TitleofCourtesy = 'Ms.' or TitleofCourtesy='Mrs.'
select * from employees where TitleofCourtesy = 'Ms.' or TitleofCourtesy='Mrs.'
and Title='Sales Representative'
select * from employees where Title=' Sales Representative' and TitleofCourtesy='Ms.' or TitleofCourtesy='Mrs.'
select * from customers Where Contacttitle like '%Manager%'
select * from customers where Phone is NULL or Fax is NULL
select * from customers where region is not NULL
select * from products where UnitPrice >10 and UnitPrice<90
select * from products where UnitPrice BETWEEN 10 AND 90 order by UnitPrice DESC
select * from Orders where OrderDate Between '2/6/1997' AND '3/11/1998' order by Orderdate desc
select (UnitPrice * Quantity)-((UnitPrice * Quantity) * discount) as AmountPaid from "Order Details"
where UnitPrice > 587.3749
select UnitPrice from Products where UnitPrice > (select avg(UnitPrice) from Products) order by UnitPrice asc
select UnitPrice,(select Avg(UnitPrice) from Products)as AverageAmount,
UnitPrice -(select Avg(UnitPrice) from Products)
as Differences from "Order Details"
select Productid from Products where ProductName LIKE '%Queso%'
union
select Productid from Products where ProductName LIKE '%Sauce%'
select a.OrderID,b.ProductId,c.ProductName from Orders a
INNER JOIN "Order Details" b ON a.OrderId = b.OrderID
INNER JOIN Products c ON b.ProductId = c.ProductID
order by a.OrderID
select * from Orders
select distinct(EmployeeID) from "Orders"
select distinct(a.EmployeeID),b.Firstname,b.Lastname
from Orders a
inner join Employees b on a.EmployeeID=b.EmployeeID
select a.OrderID,a.ShipVia,b.CompanyName from Orders a
inner join Shippers b on a.ShipVia=b.ShipperID
select a.*, b.* from shippers a
cross join employees b
select * from Products
select distinct ProductID from "Order Details"
select a.productID,b.ProductName from "Order Details" a left join Products b on
a.ProductID=b.ProductID where a.ProductID is NULL
———
https://betterflashanimation.com/
https://www.toonboom.com/main/
———
https://www.homeandlearn.co.uk/NET/vbNET.html
———
https://i.thiyagaraaj.com/articles/articles/createafreewebsites
———
www.webnode.com
www.yola.com
———