"Databases and Queries" Please respond to the following:


label Computer Science
account_circle Unassigned
schedule 1 Day
account_balance_wallet $5

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
Nov 18th, 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