Sql query help urgent(edited)

[Prince_Fan]

kashtam chinnu ilanti difficult requirements  

[reality]

1 hour ago, gupta24 said:

Table: 

Domain  sn.   Db.     Env.      Su

Ab.           S1.   Acq.    Dev.    3

Ab.            S3.   Acq.   Qa.      3

Ab.             S2.   Acq.   Qa.     3

Ab.            S4.     Acq.    Pro.  3

Result: 

Domain.  Db    su.   Dev.    Qa.           Prod  Ab.         Acq.   3.     S1.     S3,s2.         S4 

 

Paina result la ravali plss help.

Transposing columns to rows?

[Biskot]

1 hour ago, gupta24 said:

Table: 

Domain  sn.   Db.     Env.      Su

Ab.           S1.   Acq.    Dev.    3

Ab.            S3.   Acq.   Qa.      3

Ab.             S2.   Acq.   Qa.     3

Ab.            S4.     Acq.    Pro.  3

Result: 

Domain.  Db    su.   Dev.    Qa.           Prod  Ab.         Acq.   3.     S1.     S3,s2.         S4 

 

Paina result la ravali plss help.

Clear ledhu vayya ?? 

[KharjuraNaidu]

47 minutes ago, charygaru said:

5+ yrs nunchi okate degara chesthunna inka 80 K salary etla untado kuda telvadu anappude neeku ardham ayyipovaali naa talent endo antha telive undi unte manchiga edo oka travelling job chesukunta oorlu tirguthunde laudalo sodhi goda ki kottina pidaka lekka eeda ne unna 

[4Vikram]

45 minutes ago, TensionNahiLeneka said:

neeku inka raale job? 

[4Vikram]

1 hour ago, charygaru said:

nanne nooki dengelaa unaru aagu iddaram edanna gudi mundu kurchundam 

Poni adi ana better emo fermanent fosition untad 

[Picha lite]

42 minutes ago, charygaru said:

5+ yrs nunchi okate degara chesthunna inka 80 K salary etla untado kuda telvadu anappude neeku ardham ayyipovaali naa talent endo antha telive undi unte manchiga edo oka travelling job chesukunta oorlu tirguthunde laudalo sodhi goda ki kottina pidaka lekka eeda ne unna 

Epudu adigina 80k ne antav bonus lu istara leda mottaa 

[Amrita]

https://stackoverflow.com/questions/1076011/how-can-multiple-rows-be-concatenated-into-one-in-oracle-without-creating-a-stor

 

Try the above link and modify for ur case. Ur Q seems to be wrong though. Hope it works out.

 

Data Set:

question_id    element_id
1              7
1              8
2              9
3              10
3              11
3              12

Desired Result:

question_id    element_id
1              7,8
2              9
3              10,11,12

[charygaru]

1 hour ago, Picha lite said:

Epudu adigina 80k ne antav bonus lu istara leda mottaa 

last year bonus 795 ichharu taxes ponu 365 emo ochhai rojuki oka rupai choppuna ichharu laddu lo bonus antha kante iyyakunna bagane untunde 

[karthikn]

3 minutes ago, charygaru said:

last year bonus 795 ichharu taxes ponu 365 emo ochhai rojuki oka rupai choppuna ichharu laddu lo bonus antha kante iyyakunna bagane untunde 

   <okkadu 100 rupees mahesh.gif>

[karthikn]

1 hour ago, Amrita said:

https://stackoverflow.com/questions/1076011/how-can-multiple-rows-be-concatenated-into-one-in-oracle-without-creating-a-stor

 

Try the above link and modify for ur case. Ur Q seems to be wrong though. Hope it works out.

 

Data Set:

question_id    element_id
1              7
1              8
2              9
3              10
3              11
3              12

Desired Result:

question_id    element_id
1              7,8
2              9
3              10,11,12

sql king aa nuvvu 

[charygaru]

3 minutes ago, karthikn said:

   <okkadu 100 rupees mahesh.gif>

neekedo biskit love story undi anta kada naaku atla undi job !! free aithe oka thread esi nee story malla oka sari cheppu vini taristha    

[karthikn]

Just now, charygaru said:

neekedo biskit love story undi anta kada naaku atla undi job !! free aithe oka thread esi nee story malla oka sari cheppu vini taristha    

matrimony biscuit stories unnayi but no lovvu puvvu 

[charygaru]

1 minute ago, karthikn said:

matrimony biscuit stories unnayi but no lovvu puvvu 

mooth valdengukoniki ye story aithe endi le ee weekend naaku opeddaga pani moddaem ledu cheppu vinta 

[4Vikram]

3 minutes ago, charygaru said:

mooth valdengukoniki ye story aithe endi le ee weekend naaku opeddaga pani moddaem ledu cheppu vinta 

Nee story link pamputha ani two years aindi Inka raledu