How to order events tab by @Elapsed desc

[DomZZ]

I know I can do this :
select *, @Elapsed from stream order by @Elapsed desc limit 100

but I want to have the same output than the default one (the one without any query) :

How can I achieve this ?

Thanks

[liammclennan]

Hi @DomZZ

You can't. The closest would be something like select ToIsoString(@Timestamp), @Message, @Elapsed / 10000 as elapsed_ms from stream order by elapsed_ms desc.