I have a table like this Table Name:Products Productid Price 1 10

I have a table like this
Table Name:Products
Productid Price
1 10
1 10
2 20
3 30
3 30

But i want to output like this.
productid price
2 20.

please replay me.

Question Posted / rameshrr25

3 Answers
6003 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 ..

Answer / siri

select * from table name where price=20

Is This Answer Correct ?

3 Yes

0 No

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 ..

Answer / pkunde

SELECT PRODUCTID, PRICE, COUNT(*) AS CNT FROM PRODUCT
GROUP BY PRODUCTID,PRICE HAVING CNT = 1

Is This Answer Correct ?

0 Yes

0 No

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 ..

Answer / venkataselvaraj@gmail.com

SELECT PRODUCT_ID, PRICE FROM PRODUCTS
GROUP BY PRODUCT_ID, PRICE
HAVING COUNT(*) = 1;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer