我有一个mysql表,如下所示:当访问者访问网站时,它将访问者id和页面id存储为一行。SELECT COUNT(visid),visid FROM vislog GROUP BY visid ORDER BY COUNT(visid) DESC
但我不知道下一步该怎么计算可以像MySQL查询一样做吗?
当我将适配器插入膝上型计算机时,我会在syslog中得到以下消息:Oct 31 23:42:46 eris kernel: [17882.073165] usb 2-6: new full-speed USB device number23 using xhci_hcd
Oct 31 23:42:46 eris kernel: [17882.204575] usb 2-6</em
假设我有2-6,通过使用下面的程序,我可以生成范围DECLARE @startRange INT = PARSENAME(REPLACEDISTINCT Number = numberWHERE number BETWEEN @startRange AND @lastRangeDECLARE @range VARCHAR(50) = '2-6,9