Hi,
I'm having this type of queries, how can i run this in splunk:
SELECT FROM (SELECT rval.,ROWNUM as rn FROM(
select count(*) as count,count(1) over() as tcount, Xipm as location from documentreporting where xidcprofile='IpmApp_1' and XIPM_APP_1_9 is not null group by XIPM_APP_1_9
rval )WHERE rn >=1 AND rn <= 100
... View more