"Databases and Queries" Please respond to the following:

Computer Science
Tutor: None Selected Time limit: 1 Day

Imagine a new employee is unclear about sorting querie and is getting conflicting information from other programmer.Describe the difference betwen the SELECT statement and the WHERE statement;provide example of each and explain they should be used.

Feb 21st, 2015

Select Statement:- It is used to select data from a database. 

Syntax:-SELECT column_name,column_name FROM table_name;

Example:- Select Productname, ProductId from Product;

Where Statement:- The WHERE clause is used to extract only those records that fulfill a specified criterion.

SELECT column_name,column_name FROM table_name WHERE column_name operator value;

Example:-Select Productname, ProductId from Product where Product_Desc ="Laptop";

Feb 21st, 2015

Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.
Click to visit
The Notebank
...
Feb 21st, 2015
...
Feb 21st, 2015
Mar 27th, 2017
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer