- Search Statements:
- Wild Cards allow a user to search for data that starts or end with a certain character (%n or _t)
- Comparisons like less than or equal to (x>=y, x=y, x<>y means not equal to)
- Input and Retrieve Data:
- "Insert" obviously inserts data
- "Select" chooses a column
- "Where" can be used to specify certain data (WHERE x=y)
- "From" can be used to specify a table
- "And", "Or", "Between", and "Not" can be used to make more complex statements with more restrictions
Tuesday, October 29, 2013
SQL Guide Chapter 4
Chapter 4 deals with SQL Commands like
Subscribe to:
Post Comments (Atom)
That's what happens. Simple, elegant, and powerful ideas quickly become very difficult to wrap your head around as complexity of implementation grows. I think that's where the expression, "the devil is in the details" comes from ;-)
ReplyDelete