Hi everybody,
I learnt a new trick, if you want to select random record from SQL Server, you can use
select top 1 myFieldList from myTable order by NewID()
I'm wondering, what would be Access analogue?
I've ran a search on google, but came with nothing...
What is the way to get random record in Access database? Or in Oracle?
Thanks in advance.
If it's not broken, fix it until it is.
My Blog