Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Stay with one of each

nrql

#1

Hello
My problem is the following

if I have the following:

name | ate
pepe | Apple
jose | pear
pepe | pear
mark | bana
pepe | watermelon
marck | watermelon

I want a query that left me

name | ate
pepe | Apple
jose | pear
mark | bana

I mean that I left the whole row but only the last of each one, fixing ourselves in the name

or if I look at the fruit
pepe | Apple
jose | pear
mark | bana
pepe | watermelon


#2

2 posts were merged into an existing topic: Is it possible to keep a record and only one of all the repeats that there may be of a field?


#3