Build SQL Query: Most Popular Phrases With a Variable

I need a SQL query that will return a set of frequently used patterns / word combinations in a field, as well as the number of matches found for that pattern in the field.

Any amount of text could exist before or after the pattern that's shown.

I should be able to add Where clauses to the query to filter the dataset that's used for the query.


Table [login to view URL] has several tickets with the following phrases:

can't connect to facebook website

can't connect to google website

can't connect to msn website

Pattern that should appear in SQL results: can't connect to X website

Number of matches: 3

Квалификация: SQL

Показать больше sql query tree structure records, asterisk call forward database sql query, sql query child child, sql select first record, top 10 sql queries, sql: selecting rows where column value changed from previous row, select max over partition by sql server, tableau initial sql select, how to get previous row value in sql, sql select single row, select number of rows sql, sql query tree children, getafreelancer message sql query help needed, specialise sql query, sql query find number child elements, design sql query forum tree, simple sql query creator, sql query parent level, questions sql query oracle 10g, freelance sql query

О работодателе:
( 5 отзыв(-а, -ов) ) Kingwood, United States

ID проекта: #17821557

26 фрилансеров(-а) в среднем готовы выполнить эту работу за $104


Hi I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. I Больше

$150 USD за 3 дней(-я)
(59 отзывов(-а))

SQL in not designed for these types of problems, it is better to do it with C# or any other language. However, I can do it on SQL which will be much complex. I can use string matching algorithms like "Cosine simi Больше

$200 USD за 5 дней(-я)
(31 отзывов(-а))

Hi, I would like to write sql code for getting the frequently used pattern. Get in touch to discuss more. Available to start now. Regards, Manish

$100 USD за 6 дней(-я)
(48 отзывов(-а))

Hello! I am a Computer Engineer, with a MCSA SQL Server 2014 certification, with 12 years of experience using SQL, queries, reports and dashboards design and construction, database management, data warehousing, and dat Больше

$100 USD за 1 день
(11 отзывов(-а))

Hey A SQL expert developer is here I have good advanced expertise in mySQL Queries I can help you in mysql query as per your need This is an initial bid Feel free to message me Regards

$50 USD за 0 дней(-я)
(11 отзывов(-а))
$111 USD за 3 дней(-я)
(8 отзывов(-а))

Hi I have excellent database design skills. Based on your requirements, I can create an elegant solution for you. I might use stored procedures to create your query, but we will based on our initial discussion Больше

$250 USD за 3 дней(-я)
(1 отзыв)

Fullstack developer here, I can deliver what you need in 1 day or less, please provide a list of table and columns in each table. I am also expert in automating reports from database so this one will be completed as ex Больше

$100 USD за 1 день
(1 отзыв)

Could you please provide more information on the requirement, as to whether a stored procedure would have to be built and what is the table/fields to be queried for the match? Cheers, Ranjana

$111 USD за 3 дней(-я)
(2 отзывов(-а))

Hello I have read your project description and would like to do it for you right now. Please reply me to discuss more about the same. Thanks

$50 USD за 1 день
(3 отзывов(-а))

Hello, Hope you are doing well. I am a web developer and I have more than five years experience in MySQL an SQL. I have checked your job description and I am okay to get this done for you. You need to retu Больше

$250 USD за 2 дней(-я)
(5 отзывов(-а))

As per description of requirement, Sql query is to be create that search possible pattern in the filed with some clarity to user for customize use of query. I have been doing these kind of activity which are related Больше

$30 USD за 4 дней(-я)
(1 отзыв)

I have 20 plus years of experience in SQL and would provide a high quality solution.

$45 USD за 3 дней(-я)
(0 отзывов(-а))

I can provide you the solution with in 1 day

$155 USD за 1 день
(0 отзывов(-а))

I've been working with MySQL for almost 10 years. Comfortable with schema design, stored procedures and functions, and constructing fast queries.

$122 USD за 3 дней(-я)
(0 отзывов(-а))

I have this query ready. Let me know if you want to discuss.

$133 USD за 1 день
(0 отзывов(-а))
$88 USD за 1 день
(0 отзывов(-а))

I m a web and desktop developer with 8 years of experience in this industry ,I' m also a Database Manager,I read your project details and I understood your needs I can do what you want in the deadline just contact me Больше

$35 USD за 3 дней(-я)
(0 отзывов(-а))

i have 2 years experience in oracle data base i can do this job easily i hope you choose me for this one .

$40 USD за 2 дней(-я)
(0 отзывов(-а))

Hi, I like to apply for this job & will deliver this in 1 day. Thanks and regards, Pradeep Gunawardhana

$88 USD за 1 день
(0 отзывов(-а))