https://community.splunk.com/t5/Splunk-Search/use-subsearch/m-p/172424#M49403 <P>thank you <STRONG>woodcock</STRONG><BR /> it works perfectly. have a nice day</P> Wed, 06 May 2015 07:51:01 GMT otman01 2015-05-06T07:51:01Z https://community.splunk.com/t5/Splunk-Search/use-subsearch/m-p/172422#M49401 <P>hi every one, </P> <P>I want to make a search that could give me the same result of SQL Querie</P> <P>select id_product from products where price = (<BR /> select max price from products ) </P> <P>thank you </P> Tue, 05 May 2015 15:42:10 GMT https://community.splunk.com/t5/Splunk-Search/use-subsearch/m-p/172422#M49401 otman01 2015-05-05T15:42:10Z https://community.splunk.com/t5/Splunk-Search/use-subsearch/m-p/172423#M49402 <P>sourcetype=products | eventstats max(price) AS maxPrice | where price=maxPrice | stats values(id_product)<BR /> OR<BR /> sourcetype=products | eventstats max(price) AS maxPrice | where price=maxPrice | fields id_product</P> Mon, 28 Sep 2020 19:49:57 GMT https://community.splunk.com/t5/Splunk-Search/use-subsearch/m-p/172423#M49402 woodcock 2020-09-28T19:49:57Z https://community.splunk.com/t5/Splunk-Search/use-subsearch/m-p/172424#M49403 <P>thank you <STRONG>woodcock</STRONG><BR /> it works perfectly. have a nice day</P> Wed, 06 May 2015 07:51:01 GMT https://community.splunk.com/t5/Splunk-Search/use-subsearch/m-p/172424#M49403 otman01 2015-05-06T07:51:01Z