how to split the output to sql query.

Question

1.00/5 (1 vote)

See more:

i have a table in sql in which column name studentid. and it show like that on run the select query "select * from student" ----

studentid
101
102
103
104

but i want to show it like--

studentid studentid
101 103
102 104

how can i do it..

Posted 8-Apr-14 3:26am

TCS54321

Add a Solution

Comments

Thomas Nielsen - getCore 8-Apr-14 9:32am

eh, show that like this where?

Maciej Los 8-Apr-14 12:18pm

Based on what condition?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-04-08T04:35:00

Solution 1

Basically, you can't: because you don't know in advance how many columns you are going to be splitting it into: what if there are 6 student IDs? 5? 8? How many columns, and how many rows is that?
This kind of manipulation is much, much better done in your presentation software, not in the database.

Posted 8-Apr-14 4:35am

OriginalGriff

Comments

TCS54321 9-Apr-14 1:06am

roomid seatno classid studentid
1 1 17 101
1 2 18 102
1 3 17 103
1 4 18 104

TCS54321 9-Apr-14 1:10am

basically i want a print a exam seating plan report. In which if we have 60 student then it split into 10-10 student in 6 column.can it posible..

OriginalGriff 9-Apr-14 4:01am

And what if you have 70? 30?
Seriously: Do this in your presentation software, not in the database. Databases aren't good at that kind of thing.