Write a query that returns all pages that have been visited by at least one child (demo=’child’) and ALSO has been visited by at least one person aged 18-25 (demo=’18-25′). Your query should return a set of urls. I am not sure how to write a query that filters out results based on Two …
How to convert SQL statement to Power BI DAX?
I have no idea how to recreate the following code from SQL to DAX in Power BI: Or perhaps there is a way to operate on SQL commands in Power BI with imported and filtered tables? I want to do the SQL query on the already sliced data in Power BI. Thank you in advance 🙂 Answer You can achieve
SQL MAX on primary key, is filter condition unncessary if it is already indexed?
id is the primary key. Is date(created_at) = ‘2021-11-05′ and time(created_at) > TIME(’04:00:00’) filter condition unnecessary for Max function since studenthistory is already indexed on class_id and student_id? The only reason I added that datetime filter is because this table will…
What does SELECT followed by a SQL command as a string mean
What does something like mean? I know usually you have the column name after the select, like SELECT first_name, but what does it mean when it is in single quotes? I believe the || means to concatenate the strings. Sorry, I’m new to this and couldn’t seem to find anything about this. EDIT: Sorry I…
Why doesn’t the WHERE work in this sql query
I’m writing a SQL query that needs to only show the results where the ‘titel’ is the same as ‘Baklava’, but it doesn’t return any rows. When I try to use the query without the WHERE, is shows all the results, but I need the WHERE clause to work. Here is the query I’m …
Conditional where clause in Oracle SQL query is not working
I am trying to do a select on Oracle DB with this condition but it is not working. Table POST but when endDate is null I got the error Please help Answer The solution was to transform the Date in String, and in the select do this and (:endDate is null or pl.date_end <= TO_DATE(:endDate , ‘yyyy-MM-dd …
Oracle SQL: Using WHERE LIKE but for specific whole words / REGEXP_LIKE
I have a table of invoices with cost identifiers saved in a specific way, non always standard, like below: I would like to find invoices for a specific cost identifier. The structure of the cost is (4 or more digits)+(2 year digits) In Test case: 107621, the desired output would be ID: 2 and 3. SELECT * FROM …
SQL -Pivoting a column from a table which have Unique records
I am trying to pivot a table to Row which have duplicate records on all columns but, a unique ID Named ([log_ID]) at the last columns . I wont log_ID field pivoted and given dynamic name as log_ID_1 ,log_ID_2 …etc FYI – THE log_ID’s is not static they change at every execution’s they c…
How to merge two array if one item exist in both array?
I want to expand my city array with post code value. If the city_postcode array contain city array name record then push postcode value into city array. That’s what i want to achive somehow. city array: city_postcode array: The result I want: Answer If you can rely on the cities and post codes to be equ…
How to merge recordsets with different fields
In SQL, union can be used to append the rows of a recordset (table or query) to another one with the same fields. You can also append recordsets with different fields by combining the fields of both …