Select Query in Want unique time.
718557Apr 23 2010 — edited Apr 28 2010Please go through below detail
I have one table.
File Id, Date, Time
00001 10/12/2010 10:10
00001 10/12/2010 10:10
00001 10/12/2010 10:10
00001 10/12/2010 10:11
00002 10/12/2010 10:10
00002 10/12/2010 10:10
I want unique fileid,date and time in select query only.
If apply group by File Id, Date, Time then I want increment time +1.
New column
----------
00001 10/12/2010 10:10 10:10
00001 10/12/2010 10:10 10:12 <-- We can not set 10:11 due to it's already exist in table.
00001 10/12/2010 10:10 10:13
00001 10/12/2010 10:11 10:11
In short i would like select fileid,date,time,(Id duplicate entry then time +1 to generate uniquness).
-------------------------------------
I have do this for myself but i face this problem.
Query to fatch below all duplicate row
time+1
00001 10/12/2010 10:10 10:10
00001 10/12/2010 10:10 10:11 <-- But this enty again become duplicate due to it's already exist in table.
00001 10/12/2010 10:10 10:12
Thanks in advance.