Thursday, December 2, 2010

Short Notes SQL

SELECT *, agentname AS Expr1, due_mon AS Expr2, due_year AS Expr3, schedule_mon.*
FROM schedule_mon
WHERE (agentname LIKE '%Agent Name%') AND (due_mon = 7) AND (due_year = 2010)


SELECT *, agentname AS Expr1, due_mon AS Expr2, due_year AS Expr3, schedule_mon.*, agentgroup AS Expr4
FROM schedule_mon
WHERE (due_mon = 11) AND (due_year = 2010) AND (agentgroup LIKE 'DUS')