How can I make a query that selects a random line of an entity in the database?

How can I make a query that selects a random line of an entity in the database?

  
Hi.

This may seem a little strange, but is it possible to make a query that retrieves a random line from the database?


Thanks.
Hi Carlos,

You may use this in an Advanced Query:

SELECT TOP 1 * FROM {YOUR_ENTITY_HERE} ORDER BY NEWID()

Cheers,
Paulo Ramos