| Issue ID | USER |
| 1 | A |
| 2 | A |
| 3 | A |
| 4 | A |
| 5 | A |
| 6 | B |
| 7 | B |
| 8 | C |
Hi I am trying to fetch 20% of record for each user using sql but am able to fetch randon records can some one help me in fetching in %
MY output should be like
| ID | USER |
| 1 | A |
| 3 | A |
| 6 | B |
| 8 | C |
| Issue ID | USER |
| 1 | A |
| 2 | A |
| 3 | A |
| 4 | A |
| 5 | A |
| 6 | B |
| 7 | B |
| 8 | C |
| ID | USER |
| 1 | A |
| 3 | A |
| 6 | B |
| 8 | C |
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Puneet KankarPosted Jul 18, 2017, 1:28 PM