Group By to Distinct

Discussion in 'Databases' started by afridy, Jan 15, 2014.

0
  1. #1
    Hello,

    SELECT empno
     ,date
  FROM employees
GROUP
    BY empno
     , LEFT(date,10)
    PHP:
    how do i write this query using DISTINCT?
     
    afridy, Jan 15, 2014 IP
  2. Yassinoy

    Yassinoy Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #2
    select distinct(empno) ...
     
    Yassinoy, Feb 5, 2014 IP
  3. Nitin.Mail

    Nitin.Mail Well-Known Member

    Messages:
    456
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    135
    #3 
    SELECT distinct empno
     ,date
  FROM employees
    Code (markup):
     
    Nitin.Mail, Feb 9, 2014 IP