question

Shambhu.Kumar avatar image
Shambhu.Kumar asked

How to take count of different combination of data

I want query to take count of following combination of data Data Delhi-Mumbai Mumbai-Delhi Delhi-Kolkata I want output as Data count Delhi-Mumbai 2 Delhi-Kolkata 1 The data combination Delhi-Mumbai and Mumbai-Delhi should be considered as same
combinationscounts
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.