select * FROM /test/alert_status where identifier='222.129.134.178.1.3.6.1.4.1.2011.5.25.219.2.5.665.25.219.2.5.7' /** output() **/ ; select * FROM /test/alert_status where identifier like '222.129.134.178.1.3.6.1.4.1.2011.5.25.219.2.5.665.25.219.2.5.*' /** output() **/ ; select distinct day,class,node,summary,vtime FROM /test/alert_status /** output() **/ ;