Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
7
Reply
How to display minimum values from group?
Rocky Rocky
Jan 22 2014 12:05 AM
784
Reply
Hi Friends,
my table is:
create table tab
(
ref_group,
product,
qty
)
insert into tab(ref_group,product,qty)
values ('Milk Produtcs','Curd','25')
insert into tab(ref_group,product,qty)
values ('Milk Produtcs','Butter','05')
My expecting O/P:
groupProduct product sales free
Milk Products Butter 0 05
here i wanna show lowest product value from group how to make a code?
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
functions in sqlserver ?
query