i want to display data like this

Question

2.50/5 (4 votes)

See more:

My table data looks like this:

emphead-tablename
====================
empid ename

1 Jayakumar <br />
2 David <br />
3 Kutty

empdet-tablename
===================
id empid name amt

1 1 Jayakumar 4500 <br />
2 1 Jayakumar 9500 <br />
3 3 kutty 2500

I need output like this:

1 1 jayakumar 9500 <br />
3 3 kutty 2500

Posted 14-Jul-11 4:18am

shilpa-pandit

Updated 14-Jul-11 4:34am

Kschuler

v2

Add a Solution

Comments

Joan M 14-Jul-11 10:23am

Houstooon we have a problem... :) Shilpa-pandit, you should tell us which language are you useing... of course we know you are using SQL and that you have some data in tables... now... which software are you using in order to show that data? C, C++, HTML, PHP? Then we will be able to give you some advice...

[no name] 14-Jul-11 10:49am

Does it really matter if she uses C or C++ or HTML for the front-end? All you have to do is to give her the SQL query that will produce the desired output.

Joan M 14-Jul-11 10:55am

Well given the question made I've understood that the OP wants to "show" the data... and in order to show it... the OP doesn't need only a SQL query... probably I've misunderstood the thing...

shilpa-pandit 14-Jul-11 20:30pm

dear sir
we are used asp.net

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2011-07-14T04:24:00

Solution 1

Try

SELECT empid,name,  MAX(amt) 
FROM employees
GROUP BY empid;

Posted 14-Jul-11 4:24am

Abhinav S

Updated 14-Jul-11 18:55pm

v2

Comments

Uday P.Singh 14-Jul-11 14:26pm

my 5!

Abhinav S 15-Jul-11 0:55am

Thanks.