What are the steps or procedure to take in manipulating complex databases and presenting complex information so that it is understandable to users ?
Is there are SQL query which could help to present the complex information in easy understandable format ?
Any further Suggestion or resource would be quite helpful.
it depends. can you post some examples of what you have and what you want to see?
1 Like
Sounds like an interview question.lol
...or a theoretical question! Short of using column aliases and carefully chosen words, the query cannot do anything to present it in an easy to understand format. There are the CONVERT, CAST and FORMAT functions to do things with dates, etc, but that would be for the data.
Consider SSRS