I have a database named newbase and columns are
1. Itid
2. Itname
3. Itprice
4. Itquantity
I get the sum of the price using itname and the query is
select SUM(itprice)as total from trick where itname=’a’I got the result but now problem is that I want to get other columns data with some addition in the query on the form
I am developing a win application vb.net 2005 and sql server 2000 tools I am using can any one make the query
Jump to PostWhat exactly do you want in new query?
What exactly do you want in new query?
What exactly do you want in new query?
More elaboration what I want
Trick
Itid itname itprice itquantity
1 a 5 6
2 a 4 3
4 p 8 3
Query
select SUM(itprice)as total from trick where itname='a'
result
10
I want the full to display in data grid and for that I need query ok
Like
Itid itname itprice itquantity total
1 a 5 6 10
2 a 4 3
just i want is query thanks
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.