SQL
mowensky
这个作者很懒,什么都没留下…
展开
-
Oracle获取最新插入的字段值
DECLARE newMAS_ID NUMBER; begin INSERT INTO MU_ALARM_STRATEGY (MAS_ID, MAS_NAME, MAS_INSERT_TIME, MAS_UPDATE_TIME, MAS_USER_ID) VALUES (0, 'testtt', to_date('2013-07-03原创 2013-07-03 13:55:23 · 734 阅读 · 0 评论 -
sqlserver查找包含关键词的视图
WITH tab AS ( SELECT a.name , a.[type] , b.[definition] FROM sys.all_objects a , sys.sql_modul原创 2016-04-07 15:48:47 · 949 阅读 · 0 评论 -
mysql实现分组排序
set @a=0; set @rn = 1; SELECT t.a,t.b,t.c,t.rn from( SELECT t.*,case WHEN @a = a THEN @rn := @rn + 1 ELSE @rn := 1 END as rn ,@a := t.a aa from( SELECT 1 a,2 b,1 c UNION SELECT 1 a, 3 b,2 c ...原创 2018-04-02 13:32:08 · 313 阅读 · 0 评论