You could also do it non-generically and unattractively and probably inefficiently like this (will select records 11-20):
SELECT TOP 10 * FROM
(SELECTTOP 10 * FROM
(SELECT TOP 20 * FROM division ORDER BY div_code ASC ) AS myTop20
ORDER BY div_code DESC) AS myTop10Desc
ORDER BY div_code ASC
Terri|||Thank you very much.|||tmorton.. that's just sexy!
Hi, all experts here,
Thank you very much for your kind attention.
I have a question on sequence clustering algorithm. As generally it is used for sequence analysis especially for web path visiting analysis. Besides that, what else scenarios could we apply this algorithm as well?
Thanks a lot in advance and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
It is specifically for sequence analysis, but the sequence can be anything.
E.g. operations at work, product purchase order, user-behavior studies, tv-channel surfing etc. etc. Whenever you have arbitrarily different sequences of distinct events you can use the SC algorithm to understand the sequences involved. One limitation is that the algorithm works well only with a limited number of sequence states. For example, if I tried to sequence ALL web pages on SQLServerDataMining.com, it likely wouldn't work well, but if I classified pages by type, e.g. home page, tip/trick, whitepaper, download, image, etc, and sequenced the types, it could give a lot of insight.
|||Hi, Jamie,
Thanks a lot for your advices. So as you kindly advised, the SC algorithm works well to cases with limited number of states, could you kindly advise me further like, to what extent the limited number of states are? Hope my question is clear for your further advices.
Thanks a lot.
With best regards,
Yours sincerely,
|||Generally less than 100. If you think about it, it's hard to find web sites with more than 100 types of pages.....|||Hi, Jamie,
Thanks a lot for your advices.
Best regards,
Yours sincerely,
