Thursday, March 8, 2012

Thursday, July 14, 2011

Sunday, November 7, 2010

scanf


int i, userNum;
NSLog(@"Enter a number");
scanf("%i", &userNum);
for(i = 1; i<=userNum; i++)
NSLog(@"%i", i);

Wednesday, April 28, 2010

joins

  • JOIN: Return rows when there is at least one match in both tables
  • LEFT JOIN: Return all rows from the left table, even if there are no matches in the right table
  • RIGHT JOIN: Return all rows from the right table, even if there are no matches in the left table
  • FULL JOIN: Return rows when there is a match in one of the tables

sql

SELECT E_Name FROM Employees_Norway
UNION
SELECT E_Name FROM Employees_USA