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 - 2006-03-02 : 08:05:39
|
| Bahrudeen writes "Hi.. hw to use Select query for both distinct and *(eg) select * , distinct(building_id) from g_building where (condition)i want all information with distinct building id..give a solutionadvance thanx..." |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-02 : 08:07:43
|
| Hi Bahrudeen, Welcome to SQL Team!If, say, there are two rows for a given builing_id what do you want the SELECT * to display?Because if you display all the columns, assuming that there are some differences, it can't really be displayed as one row!Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-02 : 08:14:04
|
| Sounds that you are trying to suppress the column if duplicatedPost some sample data and the result you wantMadhivananFailing to plan is Planning to fail |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Using Distinct and * in select