What should be SQL query for Oracle? -

-

Text after "

This is an exact copy of the question:

  • 2 replies

    I do not have much experience Is with SQL

    I would like to table, 

      DEST_NAME DEST_ID tag India General -1 XDHKGHDJD USA SPA XLSDFASFG India spouse -1 XMAWOVMNF India General -1 XKILDKVMF India General -1 XPAWOVPOF USA SPA VJSJGHSKL   
     I,  
      DEST_NAME DEST_ID tag India General -1 XDHKGHDJD India General -1 XKILDKVMF India General -1 XPAWOVPOF United States US SPA XLSDFASFG United States SPA VJSJGHSKL India spouse -1 XMAWOVMNF   
     Actually, I priced by themselves in accordance with DEST_NAME and DEST_ID You want to record.  
     I try to use on the basis of the group, but that I need to do an overall job in the selection statement for how can I do this?   
     
     
     Try  instead of  group   
      select DEST_NAME, DEST_ID, DEST_NAME, tag your_table ordered by DEST_ID   
     but the sequence is understood me you show up is not an I would expect:  
      DEST_NAME DEST_ID tag India General -1 XDHKGHDJD India General -1 XKILDKVMF India General -1 XPAWOVPOF India spouse -1 XMAWOVMNF USA SPA VJSJGHSKL United States SPA XLSDFASFG

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

.net - Creating a new Queue Manager and Queue in Websphere MQ (using C#) -

-
"itemprop =" text "> I am writing applications that use WebSphere MQ to send messages. My unittests (for flow), I want to verify that I have put the correct message on the response queue. I am trying to figure out how to do this. My main obstacle is that I think it might be scary to clear the queue before running in my queue because the same queue can be used by other applications, I thought a decent solution would be a new line The manager will remove the queue for my solidarity and after using it. So my question is: Is it possible to use C # by using queue manager and queue? After the For future reference and future people, who want to make queues. I thought how to make and remove IBM MQ QE (not quenhers) with PCM messaging. It is not very simple, but it can be done. We have implemented it in a library and it is being used to create and delete commands before and after integration tests. The most important part of the code in this library is shown in the...
Read more