Help with a SQL query!

[Centrox]

I have a problem. I have to do a query on a certain table, but you have to manipulate the output. Here is an example.

4 books have been purchased, and the year is 1992

Can anybody help?

 

[fredericofonseca]

Do the select as usual, and then on your application you string the output values of the fields you selected with the strings you mentioned.

As you don't say which application you are using it's hard to help more.

But I'm sure you know how to use select and some of the concatenation operators do you not?? If not then do read your DB manuals as they will have a good answer for you.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[LKBrwnDBA]

Yes, true...

The solution may require extrapolating the status of 4 purchased books within a dense rank partition of date = 1992; obviously using a high-level parallelizing agent derived from an optimized high-speed virtual knowledge-based architecture.

Or in other words, take a look here.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb