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.
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
SELECT column_name,column_name FROM table_name WHERE column_name operator value;
Example:-Select Productname, ProductId from Product where Product_Desc ="Laptop";
Content will be erased after question is completed.
Enter the email address associated with your account, and we will email you a link to reset your password.
Forgot your password?