I have a massive table with over 1.3B records. This table is based on web event level data. It has a uniqye key in mongo_id. The table has many duplicate records; but for these duplicate records, the …

I want to have a login page that’ll take the email and password from 2 different tables in the same database. I have a student_regis and a Uni_regis table and these both cannot be combined in the same …

in my table I have a column for a project which can have multiple project milestones (second column). Each of the milestone can have the value ‘fullfilled’ or ‘pending’ as current_status (third column)…

Currently this is what I have and I would want to parse out the userid and add it to the line below it (and before the next line that contains another userid) as a new field. The result would look …

I have this dataset that I want to group by user_id and sum the values by category id user_id category value 0 1 1 10 1 1 1 20 2 1 2 10 3 1 2 30 4 1 3 10 5 2 3 40 And I want a select returning …

Want a bool back 1 or 0 if field ‘name’ contains string ‘IOS_PROD’. Tried: case when rlike(c.name, ‘IOS_PROD’) then 1 else 0 end as IOS Returns all 0s instead of a mix of 1s and 0s as expected. How …

My query too much time to execute for fetching data. SELECT `app`.*, `pat`.`title`, `email_address`, `bad_debtor`, `county`, `date_of_birth`, `dentist_id`, `doctor_id`, `ethnicity`, `first_name`, `…

I have a table like below, there are two address primary and secondary (some EnId has 3 address): I need to convert it into a row like below: I try this SQL statement, but it returns random data. …