当前位置:首页 » 编程语言 » oracle的常用sql语句

oracle的常用sql语句

发布时间: 2024-08-06 05:31:12

Ⅰ oracle sql 语句

1. select top 1 *from (select count(BId) as cc from brrow where getdate() between T_time and B_time group by stuID) order by cc desc
2.select a.stuname,b.title,b.T_time,b.B_time from student a join
(select borrow.stuID,borrow.T_time,borrow.B_time,book.title from borrow join book on borrow.BID=book.bid) b on a.stuID =b.stuID
3.select *from student where stuID not in (select stuid from borrow where gedate() >B_time)
4.
go
create proc login
@stuid number(10),
@password varchar2(20),
@re varchar(20) output
as
declare @st number
select @st = stuid from student where stuid=@st
if isnull(@st,0)=0 return '-1'
else if @password = (select password from student where stuid =@stuid) and @password is not null rturn '0'
else return select stuname from student where stuid =@stuid
go
5.go
create function dd()
@bid number(10)
as
if ((select bid from borrow where bid =@bid) is not null )
begin
print '必须先删除借书信息记录表中所有对应于该图书的所有数据'
return
end
delete from book where bid =@bid
go

Ⅱ oracle 查询数据只要排序后的第一条记录(不用rownum=1),sql语句怎么写

1、创建测试表,

create table test_order(id number, value varchar2(50));

Ⅲ ORACLE SQL语句

创建表插入数据:

createtabletest
(wy1int,
wy2int,
wy3int,
wy4int);

insertintotestvalues(1,11,4,5);
insertintotestvalues(2,22,4,6);
insertintotestvalues(3,33,4,5);
insertintotestvalues(4,444,null,null);
insertintotestvalues(5,555,null,null);
insertintotestvalues(6,666,null,null);
commit;

执行:

selectt1.wy1,t1.wy2,t2.wy2wy3,t3.wy2wy4
fromtestt1
leftjointestt2
ont2.wy1=t1.wy3
leftjointestt3
ont3.wy1=t1.wy4
orderbywy1;

结果:

热点内容
如何用mac管理windows服务器 发布:2025-07-03 12:41:16 浏览:382
php图片上传系统 发布:2025-07-03 12:36:00 浏览:927
我的世界服务器电脑手机都可以进 发布:2025-07-03 12:35:58 浏览:698
电信星卡19元学校网密码多少 发布:2025-07-03 12:34:39 浏览:363
java二进制读取 发布:2025-07-03 11:55:52 浏览:742
我的世界服务器记分板排版 发布:2025-07-03 11:39:22 浏览:571
安卓前期用什么处理器 发布:2025-07-03 11:37:54 浏览:872
如何更换安卓手机内存 发布:2025-07-03 11:18:52 浏览:57
魔兽清理缓存 发布:2025-07-03 10:46:38 浏览:521
神州防火墙web怎么配置代码 发布:2025-07-03 10:37:54 浏览:328