How to run this type of queries in splunk

[uma2356]

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

[woodcock]

First install DB Connect V3: https://splunkbase.splunk.com/app/2686/
Then run a search like this:

| dbxquery shortnames=t "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"