Hello All,
Question regarding the InlineQuerier transformer that harnesses SQL. I'm trying to select a random subset of records from a table. Here's the SQL code in MS-Access that works (different syntax).
SELECT TOP 200 *
FROM (SELECT Rnd(ID) AS RandomID, * FROM TableNameHere) AS TableNameRandomSelection
ORDER BY RandomID;
I think the InlineQuerier uses SQLite...correct me if I'm wrong. I'm uncertain as to which random function I should use and where to implement it within the code string.
RND()? RANDOM()? RAND()?
And can I add an argument to this function? I need to generate a random sample of records based off the table's primary key ("ID" in this case).
This code works, but it only returns the first 200 records in the table (not the random sample I'm looking for), but I feel like I'm close and just need to work a random function in there...
SELECT *
FROM TableName
LIMIT 200
