wanna help abt SQL...(urgent)

[ad.hasareli]

ane mata sql aka gahala dennako netnam bump akak wath dala yanna ada poya dawase attatama loku pinak

Machanla mekeai wenna oni...........

Hema itemcode akakama max(last) loadingnumber aken thiyena item tika display kara ganna oni.......

 

[ad.hasareli]

bmp

 

[Gayan88]

thawa poddak pahadili karanna.. therune na wenna one de..

item ekak gaththama eke anthimata apu loading number ekada one ?

 

[hirushan]

select itemcode,max(loadingNumber)
from yourtable
group by itemcode

 

[Gayan88]

select itemcode,max(loadingNumber)
from yourtable
group by itemcode

 

[ad.hasareli]

thawa poddak pahadili karanna.. therune na wenna one de..

item ekak gaththama eke anthimata apu loading number ekada one ?

thnx machn wede goda..... rep ++

select itemcode,max(loadingNumber)
from yourtable
group by itemcode

wede goda machan...... thnx a lot machan................ rep denna behelu

 

[ad.hasareli]

select itemcode,max(loadingNumber)
from yourtable
group by itemcode

me SQL aka hari machan.... mata itemname akath display karaganna oni machan..

select itemname,itemcode, max(loadingNumber)
from loading
group by itemcode,itemcode

ithin mama me widihata sql aka liya gatta bt data duplicate wenawane .... plz machan help meeeeeee

 

[flag au:]

bump
ai ban sql ma alagena dagala neee

 

[flag au:]

bump
ai ban sql ma alagena dagala neee

 

[ad.hasareli]

bump
ai ban sql ma alagena dagala neee

SQL igana ganna godak asai ban a wagema project ake bagayakma thiyenne SQL akai ban..... matat den epa wela ban

 

[ad.hasareli]

bmp

 

[san1020]

me SQL aka hari machan.... mata itemname akath display karaganna oni machan..

select itemname,itemcode, max(loadingNumber)
from loading
group by itemcode,itemcode

ithin mama me widihata sql aka liya gatta bt data duplicate wenawane .... plz machan help meeeeeee

SELECT DISTINCT itemname,itemcode, max(loadingNumber)
from loading

try this .

 

[Welusumana]

mata theruna vidihata ubata one mekada.ubata ona eka poddak explain karapan.


select itemname,itemcode, max(loading)
from loading
group by itemcode

 

[ad.hasareli]

SELECT DISTINCT itemname,itemcode, max(loadingNumber)
from loading

try this .

same machan..... recodes group by itemname dipu gamam recodes duplicate wenawa ban.....

mata theruna vidihata ubata one mekada.ubata ona eka poddak explain karapan.


select itemname,itemcode, max(loading)
from loading
group by itemcode

ow machan oka tamai wenna ona.....
mata mekan itemname akath dispaly kara ganna oni

select itemcode, max(loadingNumber)
from loading
group by itemcode



select itemname,itemcode, max(loadingNumber)
from loading
group by itemcode,itemname

mehema dipu gaman recodes duplicate wenawa ban.... akat karanna deyak kiyapanko.....

 

[san1020]

loding table eke create table code eka dapan with data

 

[sanjayy]

Try this...

select DISTINCT itemcode,max(loadingNumber)
from yourtable
group by itemcode

Edited [sorry, i didnt see that someone already posted a similar one]

 

[ad.hasareli]

loding table eke create table code eka dapan with data

datat akka ganne kohomada machan ??????????

 

[rukey184]

ooooooooooooooooooon namak

 

[san1020]

mySQL admin, mysql workbench wage ekakin lesiyen puluwan

nathnam meka balannna

http://help.hardhathosting.com/question.php/124

 

[NO_MeRcY]

me SQL aka hari machan.... mata itemname akath display karaganna oni machan..

select itemname,itemcode, max(loadingNumber)
from loading
group by itemcode,itemcode

ithin mama me widihata sql aka liya gatta bt data duplicate wenawane .... plz machan help meeeeeee

select itemcode,max(loadingNumber)
from TEST
group by itemcode


select itemcode,max(loadingNumber),itemname
from TEST
group by itemcode,itemname

uba kiyanne 2nd query eken ena data repeat wenawa kiyalada? eka wenna baha. 2nd query eke mul ekata wada wenas wenne itemname column eka add wena ekay itemname eken group by wena ekay.

poddak dekama run karala balala kiyapan machang deken return wena rows gana wenas da kiyala . dekenma 4 rows neda return wenne.