bing
Flat 10% & upto 50% off + Free additional Courses. Hurry up!

WHERE Clause

 

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;

"0 Responses on WHERE Clause"

Training in Cities

Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

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

top

Sales Offer

  • To avail this offer, enroll before 05th December 2016.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Please use coupon codes mentioned below to avail the offer
offer-june

Sign Up or Login to view the Free WHERE Clause.