TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Nachiket P
NA
1
1.2k
Tricky SQl Querry Select Querry
May 28 2012 4:01 PM
Consider a table
Sales
SAleId Saledate CustomerID
1 1-may-2012 1
2 1-may-2012 3
3 2-may-2012 1
4 2-may-2012 2
5 3-may-2012 2
i want a querry which will display
customerid saleid saledate
1 1 1-may-2012
2 4 2-may-2012
3 2 1-may-2012
Here i want to display list of customers with their first saleid and sale date
Thanks for reply Its Urgent
Reply
Answers (
1
)
select from many to many relation in sql server 2008(in visual studio 2010 professional)
Key Points while writing Query in SQL