Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Neeq a SQL query

Posted on 2011-03-10
Medium Priority
280 Views
Experts,
As per my attachment, could you please get me a query?
test.docx
0
Question by:Tpaul_10
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
• 3
• 2
• 2
• +2

LVL 9

Expert Comment

ID: 35100479
What decides if 1233 or 1234 from Table1 should be selected?

Ss
0

LVL 32

Assisted Solution

Ephraim Wangoya earned 200 total points
ID: 35100520

select A.Column1, b.Column1, MAX(A.Column3) [Column3]
from Table1 A
inner join Table2 B on B.Column1 = A.Column2
group by A.Column1, b.Column1
0

LVL 143

Expert Comment

ID: 35100522
I presume you need to review the specs ... because I don't see an explanation why table2 is actually needed, and I see no explanation on why row2 from table1 is returned and why not row1.

http://www.experts-exchange.com/A_3203.html
0

LVL 32

Expert Comment

ID: 35100557
My mistake

select MAX(A.Column1) [Table1 Column1], B.Column1 [table2 Column1], MAX(A.Column3) [Column3]
from Table1 A
inner join Table2 B on B.Column1 = A.Column2
group by B.Column1
0

Author Comment

ID: 35100585
Basically I need the max value from table1 and for some rows, it is returning the both the rows even though I have used max(column1) in my query. Not sure why
Thanks
0

LVL 9

Expert Comment

ID: 35100600
ewangoya,

We don't know why he is selecting one row over the other - maybe it should be max, maybe min, maybe first, maybe last ... :-)

Ss
0

LVL 32

Expert Comment

ID: 35100654

A quick look at the results tells me its max values
0

LVL 41

Accepted Solution

Sharath earned 800 total points
ID: 35101245
try this.
``````SELECT t1.Column1,
t2.Column1,
t1.Column3
FROM table1 t1
JOIN (  SELECT Column2,
MAX(Column1) Column1
FROM table1
GROUP BY Column2) AS t11
ON t1.Column1 = t11.Column1
AND t1.Column2 = t11.Column2
JOIN table2 t2
ON t1.Column2 = t2.Column2
``````
0

Author Closing Comment

ID: 35110909
Thanks for all your help guys and just to let you know I don't have to review my specs since it was pretty straight forward and I didn't specify all the columns in my tables and I wanted the maximum value.

Sharath's solution gave me the correct results. once again THANKS to all for quick response.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down â€¦
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
###### Suggested Courses
Course of the Month10 days, 12 hours left to enroll

#### 618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.