日期前一天的sql语句
数据库表AAA 字段如下
a b c
A 10 2009-01-01
A 11 2009-01-02
A 12 2009-01-03
B 23 2009-01-01
B 24 2009-01-02
B 25 2009-01-03
C 17 2009-01-01
C 19 2009-01-02
C 25 2009-01-03
要求搜索出最大的一天与最大的一天之前一天，b的比值，结果如下
A 12/11
B 25/24
C 25/19
SQL code:
sql server 2005:
select *
from (select id=row_number() over(order by c desc),* from tb) K
where id<=2
SQL code:
select m.a , cast(m.b as varchar) + '/' + cast(n.b as varchar) from
(select t.* , px = (select count(1) from tb where a = t.a and c > t.c) + 1 from tb t) m,
(select t.* , px = (select count(1) from tb where a = t.a and c > t.c) + 1 from tb t) n
where m.a = n.a and m.px = 1 and n.px = 2
SQL code:
create table tb(a varchar(10), b int, c datetime)
insert into tb values('A', 10 ,'2009-01-01')
insert into tb values('A', 11 ,'2009-01-02')
insert into tb values('A', 12 ,'2009-01-03')
insert
相关问答：
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
刚刚接触MySQL,不知道该如何去查看数据，插入数据，创建数据库、表，用哪为前辈能指教一二？
MySQL 5.1参考手册
引用
兄弟你会结贴吗？
mysql 参考手册
baidu
MySQL官方文档 http://dev.mysql.com/doc ......
字段1,字段2.....字段N,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
想要的结果是:
1,Na ......
