Remove the undated records from the Table..

[Kohli]

I have Table Sales. Like 

Date, Name, Sales

10/01/2017, Rahul, 1500

12/01/2017, manoj, 1200

13/01/2018, Krish, 1300

                       naresh, 1200

I want remove the naresh record from table 

[Frank_Hartmann · Accepted solution]

Load 
Date,
Name,
Sales
From [YourTable] where Name <>'naresh';

or 

Load 
Date,
Name,
Sales
From [YourTable] where Date<>null();

[sasis551]

Hi, try this

Load 

Date,

Name,

Sales

from loaction where date<>'';