SQL where

WHERE clause is used to select and show those rows that fulfill a specified condition.


SYNTAX :
SELECT column_name(s)
FROM table_name
WHERE column_name=operator value ;


Don't write query like:

 select * from employee_name=aman;
 

Table Name 'customers'

id

name

age

city

bill

1Tom34Paris5300
2Jhony51London 400
3Ram64Delhi20000.7
4Simon23Portland32.65



Online Execute/Compile