Sql Queries

Question

I have table that contain employee info now i want to display Employee info who have joined before 2000-2-5

What Query should i Write

I have written Select * From Empinfo where Dataofjoining> 2000-2-5

But it's displaying the all the employee beore 2000-2-5.

Please help me.

Vulpes · Answer

To get all records where the date of joining is before 5 February 2000 try: Select * From Empinfo where Dateofjoining

Abdu Rafeeq · Answer

use

Pranjal Mishra · Answer

Thank u sir Both Solutions r working.

Akkiraju Ivaturi · Answer

Your query should look like below: Select * From Empinfo where Dataofjoining 2000-2-5 ' Dates should be enclosed in single quotes and you can use >