弱弱求一个sql语句

2008-10-08 10:29:21 144 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【CTF整理】CTFhub技能树-Web-SQL注入【CTF整理】CTFhub技能树-Web-SQL注入目录【CTF整理】CTFhub技能树-Web-SQL注入SQL整数型注入SQL字符型注入SQL报错注入SQL布尔型注入SQL时间注入MySQL结构Cookie注入UA注入Referer注入 SQL整数型注入确定闭合方式：1 确定报错位有2个，（我选2注入点）得到库名得到表名得到列名得到flag SQL字符型注入确定闭合方式：1’ 【步骤和整形一样，不再使用，我这里采用sqlmap】核心语法: sqlmap -u "url+参阅读详情

表结构如下name1 num（数量） price(单价)
a 2 1
b 1 2
c 4 3
a 1 1
d 5 4
e 3 5
b 1 2
d 1 4
a 1 1
想查a\b\c\d\e\后面对应数字的和
如 name1 allnum数量和 allprice（总金额）
a 4 4
b 2 4
c 4 12
d 6 24
e 3 15

...全文

大厂嵌入式面试常考八股文及算法 1.指向已被释放或无效的内存地址的指针是野指针。互斥锁是一种用于线程同步的机制，用于确保同一时间只有一个线程访问共享资源。多态是面向对象编程中的一种特性，它允许以一种统一的方式处理不同类型的对象，通过相同的接口可以表现出不同的行为。大小端（Endian）指的是在计算机存储和处理多字节数据时，字节的存储顺序。大端序（Big Endian）：高位字节存储在低地址，低位字节存储在高地址。类似于将数字的高位放在左边，低位放在右边的表示方式。例如整数值0x12345678在内存中按照大端序排列为。阅读详情

devilli

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

scy251147 2008-12-07

打赏
举报

mark

Dragon_pan 2008-10-08

打赏
举报



--> 测试数据: @s

declare @s table (name1 varchar(1),num int,price int)

insert into @s

select 'a',2,1 union all

select 'b',1,2 union all

select 'c',4,3 union all

select 'a',1,1 union all

select 'd',5,4 union all

select 'e',3,5 union all

select 'b',1,2 union all

select 'd',1,4 union all

select 'a',1,1



select name1,allnum=sum(num),allprice=sum(price*num) from @s group by name1

beckham2537 2008-10-08

打赏
举报

人家明白的写的总额：
select name1,sum(num) allnum,sum(price*num) allprice from [Table] group by name1

zengxianggc 2008-10-08

打赏
举报

select name name1,sum(num) allnum,sum(price) allprice
from table
group by name

wxg22526451 2008-10-08

打赏
举报

select name, sum(num) as allnum,sum(num*price) as allprice from ta group by name1

-晴天 2008-10-08

打赏
举报

select name, sum(num) as allnum,sum(num*price) as allprice from ta group by name1

-晴天 2008-10-08

打赏
举报

单价还有求和的???

select name sum(num) as allnum,sum(num*price1) as allprice from ta group by name1

wer123q 2008-10-08

打赏
举报

select name1,sum(num) allnum,sum(price) allprice from [Table] group by name1

jiang5311 2008-10-08

打赏
举报

用group by语句就可以了

liangCK 2008-10-08

打赏
举报

[Quote=引用 5 楼 Haiwer 的回复:]
SQL codeselect name1,sum(num) as allnum,sum(num*price) as allprice
from tab
group by name1
[/Quote]

devilli 2008-10-08

打赏
举报

allprice（总金额）＝allnum（总数量） × price（单价）呢

linux_ch 2008-10-08

打赏
举报

select name sum(num),sum(price1) from ta group by name1

Garnett_KG 2008-10-08

打赏
举报





SELECT  name1,

        allnum=SUM(num),

        allprice=SUM(price)

FROM    tbname

GROUP BY name1

dlpseeyou 2008-10-08

打赏
举报

select name1,sum(num),sum(price) from table group by name1

昵称被占用了 2008-10-08

打赏
举报

select name1,sum(num) as allnum,sum(num*price) as allprice

from tab

group by name1

zjcxc 元老 2008-10-08

打赏
举报

SELECT

    name1,

    allnum = SUM(num),

    allprice = SUM(price)

FROM 表

GROUP BY name1

pt1314917 2008-10-08

打赏
举报

--> 测试数据: @s

declare @s table (name1 varchar(1),num int,price int)

insert into @s

select 'a',2,1 union all

select 'b',1,2 union all

select 'c',4,3 union all

select 'a',1,1 union all

select 'd',5,4 union all

select 'e',3,5 union all

select 'b',1,2 union all

select 'd',1,4 union all

select 'a',1,1



select name1,allnum=sum(num),allprice=sum(price*num) from @s group by name1

liangCK 2008-10-08

打赏
举报

select name1,sum(num) allnum,sum(price) allprice from [Table] group by name1

chuifengde 2008-10-08

打赏
举报

select name1,sum(num) allnum,sum(price) allprice from [Table] group by name1

弱弱求一个sql语句

相关推荐