Technical Gossip / Offtopic

[}|Serial_Killer|{]

K-u-d-o-s

my wp.com blog contains 209 error and 99.99% of them are generated for not using alt ( alternative text ) tag in images

btw congrats !

Golpo CSS is 100% valid.

[Ashfaq]

How are you testing this errors

[Icy]

Markup Validation Service

[habijabi]

amar akta voice record korar soft lagbe . windows er default ta to matro 1 min . ato kom e hobe na . free soft konta paoa jay ?

[Bristir Chhonde]

Originally Posted by habijabi

amar akta voice record korar soft lagbe . windows er default ta to matro 1 min . ato kom e hobe na . free soft konta paoa jay ?

Try this one bhaiaa

Audacity: Windows

[Addabaj]

duita alada database'er duita table aksathe koira common data baad diya ki vabe akta simple output deya jay?

Aki database'e tableta add kora jay, kintu somossa hoilo common konta rakhbo?

Aki naam to duijoner hoite pare, name, location, email - tinta match kore same hole baad diya dibe, amon korte parle kaj hoito

[oYn]

^^

With tempTable as ( Select * from table 1
Union all
Select * from table 2)

With Addabaj as ( Select name, email, address, count(*) from tempTable
group by name, email, address
having count(*) = 1 )

With junAddabaj as ( Select name, email, address, count(*) from tempTable
group by name, email, address
having count(*) > 1 )

With cleanTable as ( Select name, email, address from Addabaj
Union all
Select name, email, address from junAddabaj)


** eita db2 sql er code dilam, mysql er temp table create kora ta ektu diff hoite pare

[habijabi]

Originally Posted by Bristir Chhonde

Try this one bhaiaa

Audacity: Windows

thanks apu

@addabaj : if the common entries have exactly same values for all the fields, then, you can

first: append the second table with the first one.
Second: use 'group by' aggregate function or 'select distinct......' concept to eliminate the common/dupliate information

[oYn]

Originally Posted by habijabi

@addabaj : if the common entries have exactly same values for all the fields, then, you can

first: append the second table with the first one.
Second: use 'group by' aggregate function or 'select distinct......' concept to eliminate the common/dupliate information

yeh eita aro better solution distinct er kotha bhuilei gesilam, onekdin por sql use korlam

[Addabaj]

Ami root diya dibo, tomara amare banay dio plz, ami parina