Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-10 : 08:13:03
|
| sameer writes "problem is that suppose we had a table which contains fields like name , addres, telnow name can be duplicated .supposing that there r three same names "albert" with different data. I just need to get the 1st row containaing "Albert". I tried to use subquery but it didnt work." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-10 : 08:26:45
|
| How do you know which is the first row???You can use TOP... |
 |
|
|
|
|
|
question