Relative Content

Tag Archive for mysqlt-sql

T-SQL query to filter out duplicate transactions

I have been given this task for a project – “We have a single table which has the following JOB_ID, TRN_ID, MEMBER_ID, PROVIDER_ID, TRANSACTION_NAME, CREATETIME.
Write an SQL query that Identifies any duplicate transactions that may have occurred if the CTREATETIME is within 15 seconds of another. Only the JOB_ID and TRN_ID should be unique.”

mysql best way to exclude matching strings?

I have a MySQL 8 table that has several million records, around 40m
I run very frequently, specially while debugging, a query that has to exclude several “names” from that table and then group by it, so I use the “NOT LIKE” statement on the where part, is this the most performant/wise thing to do or is there something better?