title: How to get get all the data from table and if same value repeated in one column that row should count once?
body: <p><a href="https://i.stack.imgur.com/wNa8A.png" rel="nofollow noreferrer">leave_request table</a>in my table emp_id column contains duplicate data 3 times. i want to select all the data from the table and the duplicate data to count as once. here i am providing the screenshot of my table structure</p>