This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
In most cases, the operations of the In-Database tools are the same as constructing more complex queries within the standard Input tool. If you provide more information of what you'd like to achieve, we could help with the necessary syntax. For example, if you wanted to filter a table to only return records that meet a specified criteria, a WHERE clause can be added to the input query to achieve the same results.
Thank you for the clarification. I was initially attempting to do the same in the SQL Editor however when I was checking the viability of my WHERE clause by clicking Refresh, it kept returning blank results. My assumption is that there was some sort of peculiarity with the date/time (YYYY-MM-DD HH:MM:SS) stamp of my data that just wasn't jiving with the syntax of my WHERE clause.