how to select 10 random records via sql statement
i wonder how to select 10 random records via sql statement.
thank you in advanced
Your question is a little vauge because it doesnt explain how this is used within the context of FileMaker.
In a regular SQL query ( MySQL ) it would be something like:
ORDER BY RAND ()
With that being said, are you trying to do this with ESS? Import ?
thank you for answering my question.
i connected it though jdbc. so i have to write some sql statements to retrieve some records in the servlets.
i found some examples as you mentioned. but i am not quite sure whether it will apply to filemaker.(ms sql, oracle and mysql have their own version)
I tried, and it didn't work.
But thank you all the same.
Retrieving data ...