Jump to content

Sql query help urgent(edited)


Recommended Posts

Posted

 

sorry ph lo chesa indaka epudu correct ga rasta post . Edi Sql Server lo execute cheyali 

 

Table: 

Domain   col1  col2     col3     col4

Ab          S1     Acq        Dev      3

Ab           S3   Acq          Qa        3

Ab           S2   Acq          Qa        3

Ab           S4     Acq          Pro     3

Result: 

Domain         Col2      Dev        Qa          Prod     Col4

 Ab                   Acq         S1       S2,S3       S4           3    

Paina result la ravali plss help.

  • Replies 43
  • Created
  • Last Reply

Top Posters In This Topic

  • charygaru

    8

  • 4Vikram

    7

  • gupta24

    4

  • karthikn

    4

Posted
11 minutes 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.

is this the scenario of pivot??

Posted
12 minutes 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.

google  "sql values to comma separated list"

Posted
12 minutes ago, charygaru said:

sorry man only 9 yrs exp naaku intha complicated work nenu cheyyalenu 

Vuncle oka SQL job tell no nee fakana achi kusunta

Posted
24 minutes 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.

Gupta garu.. koncham clarity ivvandi sir.. please..

Posted
19 minutes ago, charygaru said:

sorry man only 9 yrs exp naaku intha complicated work nenu cheyyalenu 

9 yrs nunchi SQL ante sahasamane cheppali...recent ga meeru Data science, Machine Learning loki vellavani bayata talk

Posted
9 minutes ago, 4Vikram said:

Vuncle oka SQL job tell no nee fakana achi kusunta

nanne nooki dengelaa unaru aagu iddaram edanna gudi mundu kurchundam Brahmi-2_0.gif

Posted
10 minutes ago, charygaru said:

nanne nooki dengelaa unaru aagu iddaram edanna gudi mundu kurchundam Brahmi-2_0.gif

Nee yavva 9yrs Kelli ide cheptunav but pathukupoyav marri chettu la saami sikaram

Posted
5 minutes ago, Picha lite said:

Nee yavva 9yrs Kelli ide cheptunav but pathukupoyav marri chettu la saami sikaram

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 

Posted

Your question is not clear, if you want to display multiple row values in single row use listagg function in sql. google for examples and good luck!

Posted
1 hour ago, 4Vikram said:

Vuncle oka SQL job tell no nee fakana achi kusunta

neeku inka raale job? 

Posted
32 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 

@~`

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...