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.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  "with ties" in "Select..." query

Author  Topic  abc Starting Member 48 Posts Posted - 2001-07-30 : 07:27:33 Hello, I'm learing to use SQL, when I use Select query, the syntax of query: SELECT [ ALL | DISTINCT ] [ TOP n [PERCENT] [ WITH TIES] ] <select_list> I don't understand how and when to use with ties. I've tried to query in my table with this query, But the result can't help me to understand. Please tell me how to use ? Thanks for your help Thanks for you attention.