Grouping the words which has maximum count

Question

Grouping the words which has maximum count

May 7, 2023 at 3:27 pm

This was removed by the editor as SPAM
May 7, 2023 at 7:13 pm

This was removed by the editor as SPAM
May 8, 2023 at 11:32 am

This was removed by the editor as SPAM

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 1

sathishkm wrote:

Hi All,
I have to highest two word in the columns. It should have the maximum two words combination. I have attached the excel for reference.

So which word pairs do you want returned from...

research and operations analyst

To me, it seems that there are two 2 word titles there... Research Analyst and Operations Analyst your original data is fraught with such things.

Or, is that not important? And how do you want to treat the word "and"???

OR... is what you're really asking for is to pair every combination of individual unique words in a job title and then do a count? (I still recommend removing the word "and" there).

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sathishkm SSC Veteran Points: 228 More actions · Answer 2

Msg 8144, Level 16, State 3, Line 37

Procedure or function string_split has too many arguments specified.

Completion time: 2023-05-08T15:45:39.2855074+05:30

DesNorton SSC-Insane Points: 24278 More actions · Answer 3

sathishkm wrote:

Msg 8144, Level 16, State 3, Line 37 Procedure or function string_split has too many arguments specified.
Completion time: 2023-05-08T15:45:39.2855074+05:30

What version of SQL are you using?

How to post data/code on a forum to get the best help.

sathishkm SSC Veteran Points: 228 More actions · Answer 4

Msg 8144, Level 16, State 3, Line 38

Procedure or function string_split has too many arguments specified.

Completion time: 2023-05-08T16:53:02.0901322+05:30

Steve Collins SSCrazy Points: 2068 More actions · Answer 5

sathishkm wrote:

Msg 8144, Level 16, State 3, Line 38 Procedure or function string_split has too many arguments specified.
Completion time: 2023-05-08T16:53:02.0901322+05:30

Please run this code and paste the results. Please replace 'Your-Database-Name' with the actual name of the database you're targeting.

SELECT compatibility_level, @@version sql_rtm
FROM sys.databases
WHERE name = N'Your-Database-Name';

Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können