Debugger

Technical Article

RE: group by part of a multi column primary key

  • Reply

Here's a quick solution: SELECT t1.col1, Max(t1.col2) col2 INTO #tmp FROM t1 GROUP BY t1.col1 SELECT #tmp.col1, #tmp.col2, t1.col3 FROM #tmp JOIN t1 ON #tmp.col1 = t1.col1 AND #tmp.col2 = t1.col2 DROP TABLE #tmp --SJTerrill Edited by - TheWildHun on 06/12/2003 12:56:09 PM

2003-06-12

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers