书栈网 · BookStack 本次搜索耗时 0.016 秒,为您找到 379 个相关结果.
  • 7.9. Case

    Case PRQL SQL PRQL SQL Case Search for the first condition that evaluates to true and return its associated value. If none of the conditions match, null is returned. PR...
  • 8.2. Functions

    Functions PRQL SQL PRQL SQL Piping values into functions PRQL SQL PRQL SQL PRQL SQL Late binding PRQL SQL Functions Functions have two types of parameters: Posi...
  • 9.3. Date functions

    Date functions to_text PRQL SQL PRQL SQL PRQL SQL Date & time format specifiers Date functions These are all the functions defined in the date module: to_text Conve...
  • 2.3. Variables

    Variables PRQL SQL PRQL SQL Variables We can define a relation — similar to a CTE in SQL — as a variable with let : PRQL let top_50 = ( from employees sort...
  • 2.3. Variables

    Variables PRQL SQL PRQL SQL Variables We can define a relation — similar to a CTE in SQL — as a variable with let : PRQL let top_50 = ( from employees sort...
  • 15.2. Language design

    Language design Language design In a way PRQL is just a transpiler to SQL. This can cause its language design to gravitate toward thinking about PRQL features in terms of how t...
  • 5.11. Case

    Case PRQL SQL PRQL SQL Case Note case is currently experimental and may change behavior in the near future PRQL uses case for both SQL’s CASE and IF statements. Here’...
  • 9.1.7. Join

    Join Parameters Examples PRQL SQL PRQL SQL PRQL SQL PRQL SQL Self equality operator PRQL SQL Join Adds columns from another table, matching rows based on a conditi...
  • 5.3. Distinct

    Distinct PRQL SQL PRQL SQL Selecting from each group PRQL SQL PRQL SQL Roadmap Distinct PRQL doesn’t have a specific distinct keyword. Instead, use group and take 1...
  • 7.7. Pipes

    Pipes PRQL SQL PRQL SQL PRQL SQL Inner Transforms PRQL SQL Pipes Pipes are the connection between transforms that make up a pipeline. The relation produced by a trans...