how to get table row value of same username,same date ,but different time to get single query.

Posted by Ramsakthi under Sql Server on 11/9/2012 | Points: 10 | Views : 1643 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I want to select any rows that have another row where UserName is the same,date is the same, but the time is different in sql server.how to get table value of same username,same date ,but different time to get single query in sql server from the single table.

Ramu.R

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Krv on: 11/15/2012 [Member] Starter | Points: 25

0	select * from tablea a join tablea b on a.username=b.username and a.date=b.date where a.time<>b.time Thanks, R.Vasanth MCTS(SQL Server & BI) http://bigdatatech.blogspot.com Ramsakthi, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...