bing
Flat 10% & upto 50% off + 10% Cashback + Free additional Courses. Hurry up
×
UPTO
50%
OFF!
Intellipaat
Intellipaat
  • Live Instructor-led Classes
  • Expert Education
  • 24*7 Support
  • Flexible Schedule

When to use Where Clause in SQL?

It is used to get the data those are fulfilling the condition. If the condition is satisfied then only it fetches the data from the table.

The syntax is as follows:

Syntax:

SELECT column1, column2…..

FROM table-name

WHERE [condition];

Example:

Display students name and roll no. those who have scored more than 70.

SELECT Name, Roll-no.

From Student-details

WHERE marks>70;
Previous Next

Download Interview Questions asked by top MNCs in 2018?

Learn SQL in 16 hrs from experts



"0 Responses on WHERE Clause"

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.
top

Sales Offer

Sign Up or Login to view the Free WHERE Clause.