sql笔记

    技术2022-05-20  78

    select   *   from   ( 

    select   top   3   *   from zz_url where sortid=1 and city='中山'

    union   all 

    select   *   from   ( 

    select   top   3   *   from zz_url where sortid=1 and city='深圳' order  by   newid() 

    )a

    )

    追加随机记录


    最新回复(0)