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 |
|
Rliss
Starting Member
31 Posts |
 Posted - 2006-08-09 : 12:53:34
|
| Can anybody tell me why if there are two values that are equal SQLServer returns nothing??And if you can do that can you work around it?RLiss |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-09 : 13:02:48
|
| Question is not clear. Please Post some sample data and expected resultsSrinika |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-10 : 12:28:09
|
quote:
Originally posted by Rliss
Can anybody tell me why if there are two values that are equal SQLServer returns nothing??And if you can do that can you work around it?RLiss
Do you think you have given us enough information to answer to your question?. As asked, post some sample, expected result and the query you usedMadhivananFailing to plan is Planning to fail |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-10 : 14:09:10
|
| Max(n) denotes you want the maximum value that exist in column n.TOP n denotes you want to select to top n values from a table.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Problem using 'SELECT TOP n' or 'MAX(n)'