如何实现这个简单的查询 [英] how to implement this simple query

问题描述

亲爱的朋友解决这个简单的查询。



以下是表结构

表名：Present

Id IsPresent

1 P

2 P

3 A

4 A



在sql中写入查询，将所有'P'从IsPresent字段更新为'A'，将所有'A'更新为'P'。

预期答案：

Id IsPresent

1 A

2 A

3 P

4 P





先谢谢！

Dear Friend solve this simple query.

Following is table structure
Table Name: Present
Id IsPresent
1 P
2 P
3 A
4 A

Write query in sql to update all ‘P’ from IsPresent field to ‘A’ and all ‘A’ to ‘P’.
Expected Ans:
Id IsPresent
1 A
2 A
3 P
4 P


Thanks in advanced !

推荐答案

我们不做你的作业：它是因为一个原因而定。它就是为了让你思考你被告知的事情，并试着理解它。它也在那里，以便您的导师可以识别您身体虚弱的区域，并将更多的注意力集中在补救措施上。



亲自尝试，你可能会发现它不是和你想的一样困难！

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

这篇关于如何实现这个简单的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！