SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


query to get the name of a product with only incremental values in the quantity column


query to get the name of a product with only incremental values in the quantity column

Author
Message
sql84
sql84
SSC Veteran
SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)

Group: General Forum Members
Points: 226 Visits: 358
i need a query to get the names of the product which has incremental or equal values every year 2009-2012(in its QTY column)
Product year QTY
Computer 2009 100
Computer 2010 200
Computer 2011 300
Computer 2012 400
printer 2009 100
printer 2010 200
printer 2011 250
printer 2012 250
flash drive 2009 400
flash drive 2010 500
flash drive 2011 700
flash drive 2012 900
monitor 2009 200
monitor 2010 300
monitor 2011 250
monitor 2012 400
keyboard 2009 100
keyboard 2010 150
keyboard 2011 200
keyboard 2012 150

-------------output----------
Computer
printer
flashdrive
CapnHector
CapnHector
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5483 Visits: 1789
This looks like homework or an interview question so ill post some usable data. Can you show what you have tried so far?

CREATE TABLE tmpProduct (
Product VARCHAR(32),
[Year] INT,
QTY INT,
CONSTRAINT PK_tmpProduct PRIMARY KEY (Product, [Year])
)
INSERT INTO tmpProduct (Product, [Year], QTY)
SELECT * FROM (VALUES
('Computer', 2009, 100),
('Computer', 2010, 200),
('Computer', 2011, 300),
('Computer', 2012, 400),
('printer', 2009, 100),
('printer', 2010, 200),
('printer', 2011, 250),
('printer', 2012, 250),
('flash drive', 2009, 400),
('flash drive', 2010, 500),
('flash drive', 2011, 700),
('flash drive', 2012, 900),
('monitor', 2009, 200),
('monitor', 2010, 300),
('monitor', 2011, 250),
('monitor', 2012, 400),
('keyboard', 2009, 100),
('keyboard', 2010, 150),
('keyboard', 2011, 200),
('keyboard', 2012, 150))X(Product, [Year], QTY)




For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw

Need to Split some strings? Jeff Moden's DelimitedSplit8K
Jeff Moden's Cross tab and Pivots Part 1
Jeff Moden's Cross tab and Pivots Part 2
sql84
sql84
SSC Veteran
SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)

Group: General Forum Members
Points: 226 Visits: 358
thank you for the response. FYI this is not a homework or an interview question. i know how to create a table and insert data on it! i need a query which will give me the required result.and yes i even couldnt figure out how to start on this!!
anybody!!???
Sean Lange
Sean Lange
SSC Guru
SSC Guru (101K reputation)SSC Guru (101K reputation)SSC Guru (101K reputation)SSC Guru (101K reputation)SSC Guru (101K reputation)SSC Guru (101K reputation)SSC Guru (101K reputation)SSC Guru (101K reputation)

Group: General Forum Members
Points: 101531 Visits: 18186
Nisean (12/18/2012)
thank you for the response. FYI this is not a homework or an interview question. i know how to create a table and insert data on it! i need a query which will give me the required result.and yes i even couldnt figure out how to start on this!!
anybody!!???


Interesting....then how did this other post from today just happen to have not only the same requirements but the exact same data?

http://www.sqlservercentral.com/Forums/Topic1398007-392-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
sql84
sql84
SSC Veteran
SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)

Group: General Forum Members
Points: 226 Visits: 358
yea i jus saw tht...he is my friend ...we both are new to this forum and we both trying to figure out the solution...we tryin to delete one post but jus couldnt figure out how...man i dont get it...why everybody are acting like teachers??!!! or a spy..if u dont want to help thn jus move on.
sql84
sql84
SSC Veteran
SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)

Group: General Forum Members
Points: 226 Visits: 358
CELKO (12/18/2012)
.why everybody are acting like teachers?


Some of us are teachers. And it is our duty to find students who cheat on their homework and get them expelled from their schools for it. Over the years I have gotten two students (New Zealand, guys with "do my homework" requests) and one instructor (reproducing copyrighted materials -- my books -- without permission from my publisher).

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how, follow ISO-11179 data element naming conventions and formatting rules. Temporal data should use ISO-8601 formats. Code should be in Standard SQL as much as possible and not local dialect.

This is minimal polite behavior on SQL forums.


thank you for the explanation CELKO. it does make sense... i dont want this forum to be cheaters way out either...i am not a DBA either a student, was jus trying to learn SQL by myself. well as i said i am new and havent gone through all those formats/rules (which i should). but at least if somebody can tell me wht functions can get me to my result i could start trying them out.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)

Group: General Forum Members
Points: 340659 Visits: 42644
CELKO (12/18/2012)
Let's use {snip} and the MySQL year format:


Since this is an SQL Server forum, let's not. Besides, that break a cardinal rule... though shalt not store dates as character based data.

Untested


Why not? You've got the data and the code. Press the {f5} key and run it!

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)SSC Guru (340K reputation)

Group: General Forum Members
Points: 340659 Visits: 42644
Nisean (12/18/2012)
thank you for the response. FYI this is not a homework or an interview question. i know how to create a table and insert data on it! i need a query which will give me the required result.and yes i even couldnt figure out how to start on this!!
anybody!!???


The purpose is that a lot of people like to test their solutions before they post them. If you post readily consumable data, it makes it easier for them which means you get better answers quicker. Please see the first link after my signature line below for a more detailed explanation.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search