"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

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
Dec 4th, 2016
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