# Convert SQL query to Java Elastic Query **URL:** \ **Category:** Elasticsearch\ **Created:** [October 6, 2017, 1:34pm UTC](https://discuss.elastic.co/t/convert-sql-query-to-java-elastic-query/103017 "2017-10-06T13:34:42Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![kedarsdixit](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kedarsdixit/32/20502_2.png) [@kedarsdixit](https://discuss.elastic.co/u/kedarsdixit)\ **Post date:** [October 6, 2017, 1:34pm UTC](https://discuss.elastic.co/t/convert-sql-query-to-java-elastic-query/103017/1 "2017-10-06T13:34:43Z")
I am using Transport client to query ES. Need to convert below sql query to Java Queries: ``` SELECT id,max(timestamp2) FROM table GROUP BY id AVING timestamp1 > "2017-07-13T21:01:00.013Z" ``` I know TermsQueryBuilder and AggregationBuilder can be used for this one. But I am unable to get it right can some one please help ? ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [October 6, 2017, 9:47pm UTC](https://discuss.elastic.co/t/convert-sql-query-to-java-elastic-query/103017/2 "2017-10-06T21:47:50Z")
Given you already have another thread with a bunch of people helping, it's going to be easier to continue the discussion there, as it also has a bit more context 🙂 > [@How to parse below SQL query to ES?](https://discuss.elastic.co/t/how-to-parse-below-sql-query-to-es/102734/7): > > thanks @rockybean, I am using java APIs to pull the data, could you please help me in making use of them for above queries ? Thanks! ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [October 6, 2017, 9:47pm UTC](https://discuss.elastic.co/t/convert-sql-query-to-java-elastic-query/103017/3 "2017-10-06T21:47:53Z")