Question: In mysql how to select particular column values in a tables except particular value?
Ex: Table name is Customer , column_name is country and it has to select all country names except 'ireland'.
Answer: select country from Customer where country!='ireland';
For more sql information visit :- http://www.w3schools.com/sql/default.asp
Ex: Table name is Customer , column_name is country and it has to select all country names except 'ireland'.
Answer: select country from Customer where country!='ireland';
For more sql information visit :- http://www.w3schools.com/sql/default.asp
No comments:
Post a Comment