how to design a sql query to have sub-columns in the result?

user11665472

7/11/24, 2:53 PM

I tried several sql queries but it does not meet my expectations because in the result I cannot have sub-columns

i need to design a sql query for the following result (have sub-columns in the result):

https://i.stack.imgur.com/rkUV8.jpg

How is it possible?

3 + 0

mysql

storage

sql-server

Score:1

Server

Rick James

7/12/24, 3:41 AM

If you are referring to the column age having min_age and max_age, then use 2 columns with names like that. Here are some further tips.

WHERE age BETWEEN min_age AND max_age

CONCAT(min_age, '-', max_age) AS 'AgeRange'

+ 0

Score:0

Server

user11665472

7/13/24, 3:55 PM

I found a solution using matrix in ssrs. it concerns the presentation of data

+ 0

Score:-1

Server

TomTom

7/12/24, 5:46 AM

You do not. If you read any book on SQL the fundamental thing is that it can not have column hierarchies. The result is one simple table. Now, you can easily generate the data in the picture in columns that are not sub-columns - just combine the parent and client name - and then the only way is to make them sub columns outside of SQL. You need to understand that a table has no concept of a sub-column - what you see there is a visual representation. If your SQL is rejected because you cannot make this in SQL - someone needs a brain good enough to learn the basics of SQL. Cars do not fl. Sub columns are not a table thing.

+ 0

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: how to design a sql query to have sub-columns in the result?

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.