PTA 拓扑排序

一项工程由一组子任务构成,子任务之间有的可以并行执行,有的必须在完成了其他子任务后才能执行。例如,下图表示了一项工程若干子任务之间的先后关系。

24da0379a38eefe0c0a64bc651f56c75_673eaf16-59eb-4a3d-96f9-175acb78810a.png

 

输入样例:

在这里给出一组输入。例如:

6,5
C1
C2
C3
C4
C5
C6
0,2
1,2
1,5
2,3
3,4

输出样例:

在这里给出相应的输出。例如:

拓扑序列为:C2 C6 C1 C3 C4 C5 

代码长度限制

16 KB

时间限制

400 ms

内存限制

64 MB

 自定义队列:

#include <stdio.h>
//#include "conio.h"
#include <stdlib.h>
#include <string.h>
#define  TRUE   1
#define  FALSE  0
#define  OK     1
#define  ERROR 0
#define  OVERFLOW  -1
#define MAXSIZE 30
#define VERTEX_MAX 30   /*最大顶点数*/
#define VEX_NUM 10
typedef int Status;
typedef char Vextype[20];  /*顶点类型*/
typedef int ElemType;
typedef struct
{
    ElemType elem[MAXSIZE];
    int top;
}SeqStack;                                      /*定义顺序栈结构*/
typedef struct node       /*边结点定义*/
{
    int  adjvex;          /*邻接点域*/
    struct node* next; /*指向下一个边结点的指针域*/
}EdgeNode;
typedef struct vnode   /*表头结点定义*/
{
    int Indegree;        /*顶点入度域*/
    Vextype  vertex;     /*顶点信息*/
    EdgeNode* firstedge;
}VertexNode;
typedef struct                        /*图的邻接表存储*/
{
    VertexNode adjlist[VERTEX_MAX];
    int n, e;                            /*顶点数和边数*/
} ALGraph;


void InitStack_Sq(SeqStack& s)                     /*初始化栈操作*/
{
    s.top = -1;  //s.top从-1开始,指向实际的栈顶元素
}/*InitStack_sq*/

int Empty_Sq(SeqStack s)                       /*判栈是否为空*/
{
    if (s.top == -1)
        return 1;
    else
        return 0;
}/*Empty_sq*/
Status Push_SeqStack(SeqStack& s, ElemType x)//入栈
{
        s.elem[++s.top] = x;
        return OK;
}

Status  Pop_SeqStack(SeqStack& s, ElemType& y)//出栈
{
    if (Empty_Sq(s))  return OVERFLOW;           /* 栈空不能出栈 */
    else {
        y = s.elem[s.top];
        s.top--;  return OK;
    }                                         /* 栈顶元素存入*y,返回 */
}
void CreateALGraph(ALGraph& G) /*创建有向图的邻接表*/
{
    int i, v, w;
    int Indegree[VERTEX_MAX] = { 0 };
    EdgeNode* s;
    scanf("%d,%d", &(G.n), &(G.e)); /*输入顶点数n和弧数m*/
    for (i = 0; i < G.n; i++)
    {
        scanf("%s", G.adjlist[i].vertex);
        G.adjlist[i].firstedge = NULL;//给每个顶点的firstedge域赋初值
    }
    for (w = 0; w < G.e; w++) /*建立边表*/
    {
        scanf("%d,%d", &i, &v);
        s = (EdgeNode*)malloc(sizeof(EdgeNode));
        s->adjvex = v;
        Indegree[v]++;  /*统计各顶点的入度*/
        s->next = G.adjlist[i].firstedge;    /*前插方法*/
        G.adjlist[i].firstedge = s;
    }
    for (i = 0; i < G.n; i++)
        G.adjlist[i].Indegree = Indegree[i];
}/*CreateALGraph*/
void topsort(ALGraph& G);

int main()
{
    ALGraph g;
    CreateALGraph(g);
    printf("拓扑序列为:");
    topsort(g);
    return 0;
}

void topsort(ALGraph& G)
{
    int i, v, w;
    int cnt = 0;//计数器初始化为0
    EdgeNode* ptr;
    SeqStack st;
    InitStack_Sq(st);
    for (i = 0; i < G.n; i++)
    {
        if (G.adjlist[i].Indegree==0)
            Push_SeqStack(st, i);
    }
    while (!Empty_Sq(st))
    {
        Pop_SeqStack(st, v);//出栈一次,出栈元素放在v中
        printf("%s ", G.adjlist[v].vertex);
        ++cnt;
        ptr = G.adjlist[v].firstedge; //ptr指向第一个边结点
        while (ptr != NULL)//只要有边
        {
            w = ptr->adjvex;
            G.adjlist[w].Indegree--;
            if (G.adjlist[w].Indegree == 0)
                Push_SeqStack(st,w);
            ptr = ptr->next;
        }
    }
    if (cnt < G.n)
        printf("后续无法输出!\n");
}

 

为了处理SQL查询结果中`project_human_sum`列的重复项,并仅保留每个分组的第一个记录,可以使用窗口函数结合子查询或CTE(公用表表达式)。以下是几种解决方案: ### 解决方案1:使用 ROW_NUMBER 和外层过滤 通过 `ROW_NUMBER()` 窗口函数为每一行分配一个唯一的编号,然后在外层查询中只选择编号为1的行。 ```sql WITH RankedData AS ( SELECT (ROW_NUMBER() OVER (ORDER BY project_remark)) AS id, FORMAT(@EndDate, 'yyyy-MM') AS Nowmonth, project_remark, project_no, assembly_project, English_Name, CIP, UserType, CASE WHEN (UserType = 'a') THEN SUM(CAST(TotalUserTime AS FLOAT)) WHEN UserType = 'w1' THEN SUM(CAST(TotalUserTime AS FLOAT)) ELSE 0 END AS TotalUserTime, A_coefficient, CASE WHEN (UserType = 'a') THEN SUM(CAST(TotalUserTime AS FLOAT)) * CAST(MAX(A_coefficient) AS FLOAT) WHEN UserType = 'w1' THEN SUM(CAST(TotalUserTime AS FLOAT)) * CAST(MAX(A_coefficient) AS FLOAT) ELSE 0 END AS project_single_sum, project_human_sum, ROW_NUMBER() OVER(PARTITION BY project_human_sum ORDER BY project_remark) AS rn FROM FinalResults WHERE 1=1 GROUP BY project_remark, project_no, assembly_project, English_Name, CIP, A_coefficient, UserType, project_human_sum ) SELECT * FROM RankedData WHERE rn = 1; ``` ### 解决方案2:使用 DISTINCT ON(适用于 PostgreSQL) 如果你使用的数据库支持 `DISTINCT ON` (如PostgreSQL),你可以直接在查询中应用它来去除重复项并保留每组的第一条记录。 ```sql SELECT DISTINCT ON (project_human_sum) (ROW_NUMBER() OVER (ORDER BY project_remark)) AS id, FORMAT(@EndDate, 'yyyy-MM') AS Nowmonth, project_remark, project_no, assembly_project, English_Name, CIP, UserType, CASE WHEN (UserType = 'a') THEN SUM(CAST(TotalUserTime AS FLOAT)) WHEN UserType = 'w1' THEN SUM(CAST(TotalUserTime AS FLOAT)) ELSE 0 END AS TotalUserTime, A_coefficient, CASE WHEN (UserType = 'a') THEN SUM(CAST(TotalUserTime AS FLOAT)) * CAST(MAX(A_coefficient) AS FLOAT) WHEN UserType = 'w1' THEN SUM(CAST(TotalUserTime AS FLOAT)) * CAST(MAX(A_coefficient) AS FLOAT) ELSE 0 END AS project_single_sum, project_human_sum FROM FinalResults WHERE 1=1 GROUP BY project_remark, project_no, assembly_project, English_Name, CIP, A_coefficient, UserType, project_human_sum ORDER BY project_human_sum, project_remark; ``` 请注意,`DISTINCT ON` 的语法和功能依赖于特定的数据库系统。对于 SQL Server 或其他不支持该特性的数据库管理系统,请采用第一种方法。 ### 解决方案3:使用 FIRST_VALUE 函数 另一种方法是在聚合时使用窗口函数 `FIRST_VALUE` 来获取每个分组中的第一个值。 ```sql SELECT DISTINCT (ROW_NUMBER() OVER (ORDER BY project_remark)) AS id, FORMAT(@EndDate, 'yyyy-MM') AS Nowmonth, project_remark, project_no, assembly_project, English_Name, CIP, UserType, CASE WHEN (UserType = 'a') THEN SUM(CAST(TotalUserTime AS FLOAT)) WHEN UserType = 'w1' THEN SUM(CAST(TotalUserTime AS FLOAT)) ELSE 0 END AS TotalUserTime, A_coefficient, CASE WHEN (UserType = 'a') THEN SUM(CAST(TotalUserTime AS FLOAT)) * CAST(MAX(A_coefficient) AS FLOAT) WHEN UserType = 'w1' THEN SUM(CAST(TotalUserTime AS FLOAT)) * CAST(MAX(A_coefficient) AS FLOAT) ELSE 0 END AS project_single_sum, FIRST_VALUE(project_human_sum) OVER(PARTITION BY project_human_sum ORDER BY project_remark) AS project_human_sum FROM FinalResults WHERE 1=1 GROUP BY project_remark, project_no, assembly_project, English_Name, CIP, A_coefficient, UserType, project_human_sum; ``` 这种方法虽然有效,但在某些情况下可能会导致性能问题,特别是数据量较大的时候。 ### 总结 以上三种方法都可以帮助你在 SQL 查询中去重并保留每个分组的第一个记录。推荐使用 **解决方案1** 中的 `ROW_NUMBER()` 结合外层过滤的方式,因为它通用性强、易于理解和维护。
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值