What will be query for this table.

Question

Consumer table cno month amount 1 1 100 1 2 500 1 3 600 2 3 700 2 4 700 3 5 600 3 6 800 3 7 900 Output : cno month amount 1 1 100 2 3 700 3 5 600

Sujeet Suman · Answer

Hemlata please once try below query: WITH CTE AS( SELECT [CNO] [Month] [Amount] RN = ROW_NUMBER()OVER(PARTITION BY CNO ORDER BY CNO) FROM DB_Consumer ) Select * FROM CTE WHERE RN = 1 If this is helpful for you then please a ccept my Answer .

jeff ayan · Answer

select * from tableName where cno=12 and 3;

Hemlata Kushwaha · Answer

Now my Final Query as given below table Consumer table cno month amount 1 1 100 1 2 500 1 3 600 2 3 700 2 4 700 3 5 600 3 6 800 3 7 900 Ans. select cno MIN(month)as month MIN(amount) as amount from consumer group by cno

Hemlata Kushwaha · Answer

Your query result is given below. cno month amount 1 1 100 1 2 500 1 3 600 2 3 700 2 4 700 3 5 600 3 6 800 3 7 900 This is wrong result.

Ravi Patel · Answer

Hi Hemlata try this select distinct(cno)monthamount from Consumer