帮我创建SQL查询 [英] Help me creating SQL query
问题描述
亲爱的所有人,
我有一个表(3个字段):ProjectID,Parents项目ID,Display项目ID
数据显示如下:
ProjectID父项目ID显示项目ID
00000666 0N0005N 00000666
00000667 0N0005N 00000667
00000668 0N0005N 00000668
00000669 0N0005N 00000669
00000670 0N0005N 00000670
00000671 0N0005N 00000671
08000043 0N0005N 08000043
08000044 0N0005N 08000044
0N0005N 0N0005N 0N0005N
0N75750N 0N0005N 0N75750N
0N77770N 0N0005N 0N77770N
0N90010N 0N0005N 0N90010N
0N99900N 0N0005N 0N99900N
我希望以粗体显示的单元格是主要项目,而其他的则是子项目.
您能帮我将主项目单元格移到表格顶部吗?
非常感谢您!
Dear all,
I hvae a table(3 fields): ProjectID, Parents project ID, Display project ID
Data display like that:
ProjectID Parents project ID Display project ID
00000666 0N0005N 00000666
00000667 0N0005N 00000667
00000668 0N0005N 00000668
00000669 0N0005N 00000669
00000670 0N0005N 00000670
00000671 0N0005N 00000671
08000043 0N0005N 08000043
08000044 0N0005N 08000044
0N0005N 0N0005N 0N0005N
0N75750N 0N0005N 0N75750N
0N77770N 0N0005N 0N77770N
0N90010N 0N0005N 0N90010N
0N99900N 0N0005N 0N99900N
I wish cells in bold is main project and the others is a sub project.
Can you help me move main project cell to the top of table.
Thanks you very much!
推荐答案
如果0N0005N是您的主要项目,那么它的ParentProjectID怎么又可以是0N0005N.如果没有父项目,则理想情况下应为NULL.然后,您可以使用这样的SQL在顶部显示它:
If 0N0005N is your main project, then how can its ParentProjectID again be 0N0005N. It should ideally be NULL if it doesn''t have a Parent Project. Then you can use an SQL like this to show it at the top:
SELECT ProjectID, [Parents project ID], [Display project ID]
FROM Projects
ORDER BY [Parents project ID]
这篇关于帮我创建SQL查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!