Previously asked Question (link provided below)
http://www.aspforums.net/Threads/310843/How-to-Get-User-Details-Based-on-IP-Address-using-jQuery-in-ASPNet/
on the basis of above question i have another query
I have one table which I have recorded number of times visits in every day and per visits Query is that I want a result count visited date and result as per percentage I have to compare each and every day results as per comparing with one date result count basis
For example:
This is my table which I have recorded visit of user
id
|
visited_date
|
country
|
State
|
1
|
28/07/2017
|
India
|
Maharashtra
|
2
|
28/07/2017
|
India
|
Maharashtra
|
3
|
29/07/2017
|
India
|
Maharashtra
|
4
|
30/07/2017
|
India
|
Maharashtra
|
5
|
30/07/2017
|
India
|
Maharashtra
|
6
|
30/07/2017
|
India
|
Maharashtra
|
And I want output like this:
visited_date
|
result
|
28/07/2017
|
29/07/2017
|
Below 50%
|
30/07/2017
|
Above 50%
|
Note I want comparing result as per count basis the expected output is on count basis and also want compare with 2nd highest count
Please help as soon as possible