Code:
select column1,min(column2) from table_name group by column1
DURGAPRASAD51
Last Activity: Sep 7 '13, 10:34 AM
Joined: Sep 6 '13
Location:
-
-
I THINK THIS IS WHAT U R TRYING FORCode:SELECT * FROM ( Select XX.x, YY.y, ZZ.z, WW.w,GREATEST(XX.x, YY.y, ZZ.z, WW.w) DAT from XX Join YY on XX.x = YY.y Join ZZ on YY.ya = ZZ.z And XX.x = ZZ.zb Join WW on WW.w = ZZ.zc where x = 'my_id') DU WHERE DU.dat < somedate and DU.dat > some_otherdateLeave a comment:
No activity results to display
Leave a comment: