what wrong in this query

Question

select ModulesTask from ClientDetails where ProjectTitle ='selvi' where Statuss != 'Completed'

Santhosh Kumar Jayaraman · Answer

This is the qeury which gives you error? select ModulesTask from ClientDetails where ProjectTitle ='selvi' where Statuss != 'Completed Dont you see you are using two where clauses? i asked you to replace second where with And

Santhosh Kumar Jayaraman · Answer

You can have only one Where keyword.. try this select ModulesTask from ClientDetails where ProjectTitle ='selvi' and Statuss != 'Completed'

selvi subramanian · Answer

ya thanks santhosh

selvi subramanian · Answer

Ya i try this but not works

Kunal Vaishya · Answer

try This Dear select ModulesTask from ClientDetails where ProjectTitle ='selvi' where TRIM(Statuss) != 'Completed'

selvi subramanian · Answer

ALTER Table ClientDetails ADD Statuss VARCHAR(20) DEFAULT 'Completed' this my sql statement

Santhosh Kumar Jayaraman · Answer

You have used two times  where ProjectTitle ='selvi' where Statuss !=

selvi subramanian · Answer

s i use only one keyword