Home » SQL & PL/SQL » SQL & PL/SQL » how to avoid repetitive data from multiples data
how to avoid repetitive data from multiples data [message #200144] Sat, 28 October 2006 10:05 Go to next message
vannala_sanjeev
Messages: 3
Registered: September 2006
Location: Hyderabad
Junior Member

Hi,



>select sq.surveyQuestionId,sq.questionText,sa.surveyAnswerChoiceId,sa.answerText,sa.displayOrder,
at.answerAttributeWeightId,at.weightValue
from survey_question sq,survey_answer_choice sa,survey_answer_attribute_weight at
where sq.surveyquestionId=sa.surveyQuestionId
and sa.surveyanswerchoiceId=at.surveyanswerchoiceId
and sq.surveyQuestionId=205


OutPut Getting:

a b c d f g h
----------------------------------------------
1 Thisis 1 sometext 1 1 4
1 Thisis 2 someother 2 2 3
1 Thisis 3 somex 3 3 0
1 Thisis 4 somey 4 4 2


But I wants to display the data like below:

a b c d f g h
----------------------------------------------
1 Thisis 1 sometext 1 1 4
2 someother 2 2 3
3 somex 3 3 0
4 somey 4 4 2


Thanks
Sanjeev
Re: how to avoid repetitive data from multiples data [message #200145 is a reply to message #200144] Sat, 28 October 2006 10:17 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

sql>break on  sq.surveyQuestionId skip 1
sql>break on  sq.questionText  skip 1



Previous Topic: it keep coming up missing expression in line 1
Next Topic: Low performance with group by
Goto Forum:
  


Current Time: Wed Dec 07 08:33:51 CST 2016

Total time taken to generate the page: 0.07561 seconds