how to write querry for exact given no

[developerit]

hi iam using sql server 2000 i have a table with fields itemkey nvarchar(50) amount money i want the querry when user enters any number like 1000 or 750 i want to display what are the itemkey and the amount equals to exactly 1000 can you give example which helps me

[Johan Hakkesteegt]

I hope that I misunderstood your question or that you have simply never written sql before:

SELECT itemkey, amount
FROM a_table_with_fields
WHERE amount = 1000

My advice is free, and you may get what you paid for.

[Henry Minute]

Your question is not exactly clear. However, from what I think it means, what you need is one of the most basic of SQL statements SELECT ......WHERE ...... See here[^] for syntax etc.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[developerit]

hi , i want the querry for a given parameter how much items amount equals to given parameter

[Henry Minute]

In that case the answer given by Johan should do that.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[Luc Pattyn]

The number of matching items can be obtained using the COUNT function:

SELECT count(*) FROM a_table_with_fields WHERE amount = 1000

:)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

---

If you want my opinion or comment, ask in a forum or on my profile page; I will not participate in frackin' Q&A

---