Dear All !
Please Correct my SQL String.
sqlcmd = New SqlCommand("Select top 10 Distinct[Batch No], [Item Name],Decentralization, UOM, Balance from Decentralization order by Serial desc", conn)
When I run this Command I get Following error : incorrect syntax near the keyword 'Distinct'
Jump to PostSelect Distinct top 10 [Batch No], [Item Name],Decentralization, UOM, Balance from Decentralization order by Serial desc
Distinct should come first before top 10...
Jump to PostUse group by... Somthing like this
Select distinct ItemName,BatchNo,UOM,Department
from URTABLENAME group by ItemName,BatchNo,UOM,Department.
Include all the column in select and gropu by
Select Distinct top 10 [Batch No], [Item Name],Decentralization, UOM, Balance from Decentralization order by Serial desc
Distinct should come first before top 10...
Dear Sir;
I want Top 1 record for each Item Name, Batch No & Department. What sql code should i give ?
Use group by... Somthing like this
Select distinct ItemName,BatchNo,UOM,Department
from URTABLENAME group by ItemName,BatchNo,UOM,Department.
Include all the column in select and gropu by
Dear Sir !
My Database is : -
**From this I want this Filtured Result :- **
Please Write a code for this result.
No one will write code for you... We can just help you..
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.