"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

Did you know? You can earn $20 for every friend you invite to Studypool!
Click here to
Refer a Friend
...
Feb 21st, 2015
...
Feb 21st, 2015
Jun 28th, 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