Random selekcija i SQL

Problem:

Selektirati podatke iz tablice i poredati ih nasumično.

Rješenje:

MySQL

ako želimo samo jedan podatak ali svaki put neki drugi

SELECT polje FROM tablica ORDER BY RAND() LIMIT 1


ako želimo sve podatke prema nasumičnom poretku


SELECT polje FROM tablica ORDER BY RAND()

MSSQL 

ako želimo sve podatke prema nasumičnom poretku

SELECT TOP (100) PERCENT polje FROM tablica ORDER BY NEWID()


ako želimo samo jedan podatak ali svaki put neki drugi


SELECT TOP 1 polje FROM tablica ORDER BY NEWID()


 


 
This entry was posted on Tuesday, June 14th, 2011 at 11:29 amand is filed under MSSQL Database Development, MYSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.