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
Rocky Rocky
NA
317
151.7k
How to seperate and display the max value ?
Jan 9 2014 1:51 AM
Hi Friends,
i ve the scenario like
The list of customer's was billed on 01-apr-2011
custname products value bill_date bill_no
ram Milk 25 01-apr-2011 25
ram Perfume 225 01-apr-2011 25
sam Egg 50 01-apr-2011 26
sam Medicine 125 01-apr-2011 26
now i wanna to extract the maximum billed value from above and display on my result like
custName products Max_sales billed billno
ram Perfume 225 01-apr-2011 25
sam Medicine 125 01-apr-2011 26
how to write code for these scenario?
do the need full
thanks
rocky
Reply
Answers (
6
)
How to Make code For These Query?
How to get the count of records