Home > Default > SQL Question

SQL Question

November 30Hits:0
I want to display results in a sql in the format mentioned below.
Category is a column in one table and answrs are in another table and id is the join to connect these tables.
Category 1
Answr 1
Answr 2
Answr 3
Category 2
Answr 1
Answr 2
Answr 3
so forth.


Answered at the Javaranch

Read other 3 answers


Related Articles

  • SQL Question Bank and Answers for PractiseNovember 30

    Dear Readers: Does any one have any recommendation on SQL question bank and answers where I could practice my SQL. I have developed some basic knowledge of SQL thanks to the MS community, but I am looking for some additional Questions or textbook  re

  • Sql question : TRUNCATE vs DeleteNovember 30

    hi this is sql question, i don't know where i should post it, so here it is. i just want to know the best usage of each. both commands delete records in a table, one deletes all, and the other can do the same plus option to delete specified records.

  • Urgent SQL question : how to flip vertical row values to horizontal ?November 30

    Hello, Oracle people ! I have an urgent SQL question : (simple for you) using SELECT statement, how to convert vertical row values to horizontal ? For example : (Given result-set) MANAGER COLUMN1 COLUMN2 COLUMN3 K. Smith ......1 K. Smith ............

  • This forum is for web-SQL*Plus discussions - not SQL questionsNovember 30

    Hi folks, We'd like to keep this forum for discussions about the iSQL*Plus (Note the 'i') web-enabled front-end to SQL*Plus. We're looking for feedback on this web interface; there are obviously a number of enhancements that can be made and we'd like

  • General SQL questionOctober 11

    I have seen the following in some sql, but not sure of the difference. select abc, NULL from xyz where ..... select abc, to_char(NULL) from xyz where .... my question is there a difference between NULL and TO_CHAR(NULL) ? Thanks.BluShadow wrote: Look

  • SQL Questions (New to Cisco)October 11

    Hello. I work for Clarian Health in Indianapolis and am trying to learn as much as possible about the SQL databases, both AWDB and HDS so that I can handle the reporting for our Revenue Cycle Customer Service. I am currently working my way through th

  • SQL question- on how to handle groups of records at a time.October 11

    Hi, I have a sql that looks like the following: insert into INVALID_DATES_TMP (id, gid, created, t_rowid, updated) select id, gid, created, rowid, updated from TABLE1 where fix_invalid_date_pkg.is_date_invalid('TABLE1', 'CREATED', ROWID) = 'Y'; COMMI

  • Parent - child table issue wrt to count - SQL questionOctober 11

    I have a scenario: There are 2 tables (parent and child). lets say, case summary table and task level dimension table. for every case id in case summary table, there would be multiple tasks in task level dim table with a flag indicator set to 1 for a

  • SQL question - please help!November 30

    Hi, I am working on a SQL, please help ms with the question below .... thanks (1)Increase by 10% salary of these captain pilots who have traveled more than 800,000 miles. Routes | | Flights | |Pilots | | | | | | #routeID | | #flightNO | |#pilotID | d

  • SQL Question (Select rows with multiple records)November 30

    Hello Gurus, I am learning SQL and have a question. Thanks for your time and help. I have 2 tables TABLE_AA and TABLE_BB. Both tables have two columns ID, DATA. TABLE_AA is connected to TABLE_BB through ID field (TABLE_AA.AA_DATA = TABLE_BB.BB_DATA)

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.614 s.