CheriYu的博客

#创建带参数的自定义函数CREATE FUNCTION f2(num1 SMALLINT UNSIGNED,num2 SMALLINT UNSIGNED) returns FLOAT(8,2)return (num1+num2)/2;#调用函数select f2(10,15);#创建不带参数的自定义函数create function f1() RETURNS VARCHAR(30)re

好久好久好久没有写博客了呀~~~哈哈哈~~~Mysql查询：use test;//使用数据库select id from log_info limit 5,10//limit关键字Oracle查询：select top 10 id from log_info where id not in ( select top 5 id from log_info order by id)order b...