FAQ

Types of Application Software?

16/12/2009 12:28
Different Types of Application Software What is application software? What are the different types of application software? Know it all along with some interesting examples of application software. Read on… Computer Software Computer software is defined as a set of programs and procedures that...

Tron(OS) - one of the most widely use OS

13/11/2009 10:47
APAN'S HOMEGROWN OPERATING SYSTEM TRON Competes for the Info-Appliance Market (May 22, 2003) ...

list of Blog Sites

13/11/2009 10:36
So it seems all we ever speak about is Wordpress (), but don’t forget that you have options when choosing a blog platform. Here are 40 free ways to get started. Danga Software Powered GreatestJournal.com – Based on the same software as LiveJournal, offers free voice posts, 1GB of photo...

Types of Website

13/11/2009 10:31
What are the types of Website? Types of websites There are many varieties of websites, each specializing in a particular type of content or use, and they may be arbitrarily classified in any number of ways. A few such classifications might include:[original research?] Affiliate: enabled...

Topic: FAQ

Date 20/02/2010

By den

Subject adbms code conts

Reply

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

Date 20/02/2010

By den

Subject ADBMS CODE

Reply

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

Date 10/02/2010

By den

Subject animation tips and tutorials websites

Reply

https://betterflashanimation.com/
https://www.toonboom.com/main/

Date 01/02/2010

By den

Subject vb.net, c#.net, php tutorials site

Reply

https://www.homeandlearn.co.uk/NET/vbNET.html

Date 20/11/2009

By denz

Subject link to guide for creating website

Reply

https://i.thiyagaraaj.com/articles/articles/createafreewebsites

Date 20/11/2009

By denz

Subject favorite sub-domain site

Reply

www.webnode.com
www.yola.com