Select Only Few Rows

Our table is pretty small, so if we wanted to get some information about Volkswagens, we could select all rows and just ignore the extra few which contain other brands. But what if our table consisted of thousands of rows?

SELECT * FROM user WHERE id = 100;
Look what happened. We've added WHERE and a condition. The simplest condition looks like the one in our example - we want to retrieve information about a user with a specific id (100), so we use the equality (id = 100).


SELECT * FROM table_name WHERE column_name=value;


Execute Below code

SELECT * FROM car WHERE production_year=1999;

 


  

  

VIN

  

  

BRAND

  

  

MODEL

  

  

PRICE

  

  

PRODUCTION_YEAR

 

  

  

JF1BR93D7BG498281

  

  

Toyota

  

  

Avensis

  

  

11300.00

  

  

1999

 

  

  

1G1YZ23J9P5800003

  

  

Fiat

  

  

Punto

  

  

5700.00

  

  

1999