# A list with only one result for every entry of the original list **URL:** \ **Category:** Ask for Help\ **Created:** [November 4, 2020, 10:57am UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930 "2020-11-04T10:57:01Z")\ **Posts on this page:** 1\ **Showing post:** 7
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 4, 2020, 10:13pm UTC](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930/7 "2020-11-04T22:13:02Z")
I wrote 2 posts about Query here if you need it. > [@Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1)](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-1/10432): > > This topic was inspired by our last community meetup, in which we talked about some formulas in Google Sheets and some people want to know more about QUERY, which was branded [“The most powerful function in Google Sheets”](https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/) by famous GSheets teacher Ben Collins. So, what is QUERY, and why is it so powerful. Here’s a writeup on it, which hopefully would help many of you here in this community. Trust me, it would change so much how many of you “clean” your data in the future from raw data, in a very… > [@Tutorial - QUERY: “The most powerful function” in Google Sheets (part 2)](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-2/10849): > > If you have not read part 1, below is the direct link so you can have a read at what QUERY is, and how it can help your case, whether it be building Glide apps or make your normal day work easier. > > > **6/Dynamically sort your data using ORDER BY** > > > > An ORDER BY claused can be used to dynamically sort your data after being queried, and you can change the column that is used to sort with just a letter. By default, the ORDER BY sorts ascendingly, and it can grab the data type in the column automatically.… --- _[View the full topic](https://community.glideapps.com/t/a-list-with-only-one-result-for-every-entry-of-the-original-list/17930)._