update tableA set Gender = (case gender ='Male' then 'Female' else 'Male' end)
Subscribe to:
Post Comments (Atom)
-
Ans: A trigger is a special kind of Stored Procedure or stored program that is automatically fired or executed when some event (insert, d... -
What is Common Table Expression: Ans: A CTE (Common Table Expression) defines a temporary result set which you can then use in a SELECT...
-
The HAVING clause was added to SQL because the WHERE keyword cannot be used with aggregate functions. Example: SELECT COUNT (Custome...
No comments:
Post a Comment