I have table A which includes all data based on a read date. For example: Read Date—-Data 1/1/2016—–3 1/2/2016—–10 1/3/2016—–42 1/4/2016—–16 12/25/2016—-32 12/26/2016—-12 12/27/2016-…
Return both the largest and second largest dates, in separate columns, grouped by some factor
Been struggling with this. I need to return the largest date, grouped by some factor in 1 column, and the second largest date in a separate column. I’m unable to use DATEADD function since there …
Searching database using `LIKE` and `MATCH AGAINST` in MySQL
I have a table in my database called pro_search where I have translated the meta information for different products in different languages. My table structure is like so:id pro_id en de es fr …
Checking if any value from a comma-separated list is selected in a multi-value parameter (in SQL dataset)
I have a field in my SQL dataset that contains a comma-separated list of short 2-4 letter codes — let’s call this CodeField. I also have a multi-value Report Parameter whose available values are the …
Based on Condition Extract Values Right of String
I have a dataset in sql that looks like this: Col1 Col2 13_DND_ 5 _DND_ 6 123_ETL_ 10 ETL_ 12 DND_ 15 _ETL_ 17 If Col1 contains either _DND_ or …
MySQL Attendance Calculation
Here i have table attendances I need result as shown below How can i achieve this in mysql without using any programming language Sql File is Attendances.sql
How to ORDER BY a column from INNER JOIN
Table structure from comments: id | user_id | cmt_id | slug 1 | 565 | 5 | home 2 | 324 | 6 | home 3 | 71 | 7 | home 4 | 408 | 1 | about Table structure from …
How to select multiple ranges seperated by group id
I need to create a comma delimited list of values for each group id in a table and fill in any missing values but I’m not quite sure how to proceed. I’m using Server 2016. my table: id | …
Select entities using multiple criteria from many-to-many association entity
I’m having trouble selecting entities of type Product where the product has two or more Categories. I have following tables: product ============ product_id (PK) name category ============ …
How i make PHP/HTML images show original size onclick?
I am developing a news section that contains text and images in which the images to be clicked have to show their original size. Can someone help me with this? …