Description
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.
Explanation & Answer
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";
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Fahrenheit 451
by Ray Bradbury
My Brilliant Friend
by Elena Ferrante
Herzog
by Saul Bellow
Notes from Underground
by Fyodor Dostoyevsky
The Sun Is Also a Star
by Nicola Yoon
The King Must Die
by Mary Renault
The Jade Peony
by Wayson Choy
Heart of Darkness
by Joseph Conrad
Jane Eyre
by Charlotte Brontë