Dml join queries 1 alumni management system

Question

2.00/5 (1 vote)

See more:

C#

Write a query to display the names of the users who have posted posts and the contents of posts, sorted by name, then by post date and then by post content.

kindly send me the query coding for this.
i tried out this. but tits stating it to be a wrong answer.kindly help me with the right query coding.

What I have tried:

select user.name,post.content from user
inner join post
on user.id=post.user_id
order by user.name,date(date);

Posted 24-Apr-16 23:20pm

Member 12482945

Updated 24-Apr-16 23:58pm

v2

Add a Solution

Comments

Tomas Takac 25-Apr-16 5:22am

Not enough information. What is the problem? Do you get an error message? If yes then what does it say? Or do the results differ form what you expect? If yes then what do you get and what do you expect to get?

Suvendu Shekhar Giri 25-Apr-16 5:31am

Share the sample result set and what you want the result set to be.

Arunprasath Natarajan 25-Apr-16 5:47am

select user.name,post.content from user
inner join post
on user.id=post.user_id
order by date(date) desc, user.name
Try this

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)

Nigam,Ashish · Answer 1 · 2016-04-24T23:58:00

Solution 1

You have to write like :

select user.name,post.content from user
inner join post
on user.id=post.user_id
order by user.name,post.date,post.content;

Posted 24-Apr-16 23:58pm

Nigam,Ashish

Updated 24-Apr-16 23:59pm

v2