i want to load a column emp_name from a table employees using order by and where clause.
where emp_id is 1,2,3.
i need to load this through script
Where Match(emp_id,1,2,3) > 0
Order By emp_id
Yes, possibly she was asking for where part. '>0' part is redundant here, try like:
Where Match(emp_id,1,2,3) Order By emp_id
Where Match('EMPNO', 1,2,3);
SQL SELECT *
Order By EMPNO
Try With this
order by emp_id Asc;
Drop Table tmpSource;
it is showing script syntax error in orderby emp_id Asc;
Put space between Order By
Order By emp_id Asc;
i tried after loading it is showing garbage statement after non concatenate
Could you post your script piece?
Try with this
we need to keep the where condition after mentioning the table name .
Retrieving data ...