Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: MedievalKnight
- Order by date
-
get only one result with three different fields from same table
This is awesome! Works like a charm. I've been breaking my head on this the whole evening. Thank you very much, Christophe- MedievalKnight
- Post #10
- Forum: ANSI_SQL
-
get only one result with three different fields from same table
as an answer to your question: yes ;-)- MedievalKnight
- Post #8
- Forum: ANSI_SQL
-
get only one result with three different fields from same table
Now, I have implemented it via a left outer join, selecting only those values that are not null. But, when you have 2 email adresses for instance, you'll see 2 rows comming back, and I only want the first created one. This is the query: SELECT DISTINCT a.id, a.related_id, c.email_adres...- MedievalKnight
- Post #7
- Forum: ANSI_SQL
-
get only one result with three different fields from same table
I have a unique ID (int) column and a created_date (datetime) column. The last one could be used then?- MedievalKnight
- Post #5
- Forum: ANSI_SQL
-
get only one result with three different fields from same table
Hi, I'm affraid the First (or last) aggregate functions do not exist in SQL server. Min and max are not correct.- MedievalKnight
- Post #3
- Forum: ANSI_SQL
-
get only one result with three different fields from same table
Hi, I'm a bit stuck here. I have a table called STM_COMM and it contains following fields: id, member_id, email_addr, tel_nr, fax_nr A member can have multiple email addresses, telephone numbers and faxnumbers. so we could have something like this: id member_id email_addr tel_nr...- MedievalKnight
- Thread
- Replies: 9
- Forum: ANSI_SQL
