Mute Duck - SQL

Foundation Lightning Material Tailwind Swift Spectrum

Select Insert Update Sum Or Min and Max Limit Like Select random record Pivot Linking a parameter (in an SSRS report) Adding a specific record to the result set Is null or is not null Find tables containing column name Count rows of all tables Group by sets in a list Reference column alias Find value in database Get the Start and End of Month Find Currently Running Queries Financial Year Add/subtract dates Find columns by type

getElementById Add event listener For loops Fetch (json results) Fetch (text file)

HTML5 page structure Rewrite to https://www

Declaring and using variables Selector states

Get name of pressed button on POST Read .csv file into Array Write to .csv Compare two .csv files of different sizes Database - Connect to MSSQL Database - Connect to MySQL Database - Execute SQL query Database - Prepared Statement For loops Get DB results as json

Nothing here yet.

DimDates Sorting a visual axis by month and year Power Query - Remove last character Power Query - Remove first character DAX - Financial Year DAX - Display percentage (%) of an item DAX - Calculate % of an item DAX - Get dates from a Slicer DAX - Count rows with matching text in column Stacked bar chart (horizontal) If Statement Switch Statement Compare Dates Create new Dimension table from table Create a summarised table from table Show 0 and not Blank Filter table, count result set Load a stored procedure Text Transformations (DAX) Text Transformations (M Query) If-else statement (M Query) Pivot and Group data

Clear / Reset control(s) Button TextInput DatePicker Dropdown Toggle Checkbox HtmlEditor User Information Notifications Picture Control Attachment Control Office365Outlook Variables

Nothing here yet.

Add text to start or end of every line

Adding a specific record to the result set (i.e. '<All>').

SELECT 
      column_1
    , column_2
FROM [table]

WHERE ...

UNION ALL

SELECT
      '<ALL>'
    , '<ALL>'