SQL

Question

Post reply

SQL

jmohangokulraj

Valued Member

Points: 65
More actions
March 14, 2013 at 4:17 am

#272245

id mark
1 50
1 60
1 70
2 50
2 60
3 50
4 50
5 50
5 60
3 50 this is my table.
i need outout this
id mark
3 50
4 50

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

What about rules?

Why not

1 50

and

5 50

?

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Stuart Davies SSCoach Points: 19505 More actions · Answer 2

One answer is

SELECT DISTINCT

id ,

mark

FROM

mytable

WHERE

id IN ( 3, 4 )

but this is a guess.

Why are those records being selected? Is it based on the ID, the mark? or some other reason?

What I have supplied gives you the answer you want but it might be for the wrong reasons.

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Gazareth One Orange Chip Points: 27737 More actions · Answer 3

Hi, and welcome to SQL Server Central.

Please post and tell us how far you've got with your code & we'll try to help.

We could guess but your requirements aren't quite clear enough at the moment.

Regards