赵海旭

分类

题解(1)

/ 注册

全部文章（共5篇）

题解 | #所有的产品名称以及对应的销售总数#

select prod_name ,(select sum(quantity) from OrderItems a group by prod_id having a.prod_id=b.prod_id) quant_sold from Products b 题意：第一张表，是订单id，和订单数量...

2023-01-25

0 340

题解 | #返回每个顾客不同订单的总金额#

select cust_id ,(select sum(a.item_price*a.quantity) from OrderItems a GROUP BY a.order_num having a.order_num =b.order_num) total_ordered from Ord...

2023-01-24

0 295

题解 | #数组中的逆序对#

public class Solution { private int count =0; int [] temp=new int[100005]; public void mergrSort(int [] a,int [] tem,int l,int r) ...

2022-11-21

0 237

题解 | #在行列都排好序的矩阵中找指定的数#

import java.util.Scanner; public class Main{ public static void main(St...

2022-09-14

0 291

题解 | #判断链表中是否有环#

题解： 1.哈希：遍历链表，将链表元素记录，如果遇到相同元素相当于有环。 import java.util.*; /** * Definition for singly-linked list. *&nbs...

Java

2022-06-23

0 414