×

### Let's log you in.

or

Don't have a StudySoup account? Create one here!

×

### Create a StudySoup account

#### Be part of our community, it's free to join!

or

##### By creating an account you agree to StudySoup's terms and conditions and privacy policy

by: Lauren Heidenreich

11

0

1

Lauren Heidenreich
UH
GPA 3.89

Staff

These notes were just uploaded, and will be ready to view shortly.

Either way, we'll remind you when they're ready :)

Get a free preview of these Notes, just enter your email below.

×
Unlock Preview

COURSE
PROF.
Staff
TYPE
Class Notes
PAGES
1
WORDS
KARMA
25 ?

## Popular in Education and Teacher Studies

This 1 page Class Notes was uploaded by Lauren Heidenreich on Saturday September 19, 2015. The Class Notes belongs to CUIN 7321 at University of Houston taught by Staff in Fall. Since its upload, it has received 11 views. For similar materials see /class/208270/cuin-7321-university-of-houston in Education and Teacher Studies at University of Houston.

## Popular in Education and Teacher Studies

×

×

×

### What is Karma?

#### You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 09/19/15
Basic SQL syntax elements Statements SQL statement always begins with a SQL verb The following keywords identify commonly used SQL verbs Keyword Description SELECT Retrieves the speci ed records INSERT Adds a new row UPDATE Changes values in the speci ed rows DELETE Removes the speci ed rows Statement Use the following keywords to re ne SQL statements clauses Keyword Description FROM Names the data tables for the operation WHERE Sets one or more conditions for the operation ORDER BY Sorts the result set in the speci ed order GROUP BY Groups the result set by the speci ed select list items Operators The following basic operators specify conditions and perform logical and numeric functions Operator Description AND Both conditions must be met OR At least one condition must be met NOT Exclude the condition following LIKE Matches with a pattern lN Matches with a list of values BETWEEN Matches with a range of values Equal to ltgt Not equal to lt Less than gt Greater than lt Less than or equal to gt Greaterthan or equal to Addition Subtraction Division Multiplication

×

×

### BOOM! Enjoy Your Free Notes!

×

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

## Why people love StudySoup

Steve Martinelli UC Los Angeles

#### "There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."

Amaris Trozzo George Washington University

#### "I made \$350 in just two days after posting my first study guide."

Jim McGreen Ohio University

#### "Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."

Parker Thompson 500 Startups

#### "It's a great way for students to improve their educational experience and it seemed like a product that everybody wants, so all the people participating are winning."

Become an Elite Notetaker and start selling your notes online!
×

### Refund Policy

#### STUDYSOUP CANCELLATION POLICY

All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email support@studysoup.com

#### STUDYSOUP REFUND POLICY

StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here: support@studysoup.com

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to support@studysoup.com