jumlah digit = jumlah tabel.
jumlah huruf = jumlah record.
misalnya 5 huruf diambil 4 digit.
jadi ada 4 tabel dengan 5 record berisi masing masing A, B, C, D, E
silahkan coba ini di sql server anda.
declare @a table
(data varchar(1))
declare @b table
(data varchar(1))
declare @c table
(data varchar(1))
declare @d table
(data varchar(1))
insert into @a values ('A')
insert into @a values ('B')
insert into @a values ('C')
insert into @a values ('D')
insert into @a values ('E')
insert into @b values ('A')
insert into @b values ('B')
insert into @b values ('C')
insert into @b values ('D')
insert into @b values ('E')
insert into @c values ('A')
insert into @c values ('B')
insert into @c values ('C')
insert into @c values ('D')
insert into @c values ('E')
insert into @d values ('A')
insert into @d values ('B')
insert into @d values ('C')
insert into @d values ('D')
insert into @d values ('E')
select '(5*4*3*2*1) /(1)' as Rumus, (5*4*3*2*1) /(1) as hasil
select
a.data + b.data + c.data + d.data
from @a a,@b b, @c c, @d d
where
a.data<> b.data and
a.data<> c.data and
a.data<> d.data and
b.data<> c.data and
b.data<> d.data and
c.data<> d.data and
d.data<> a.data
order by
a.data,
b.data,
c.data,
d.data
hasilnya sbb:
salam hangat dan jabat erat,
Edy Wiyono
On 11/30/2012 19:14, Hobys Mengamati wrote:
No comments:
Post a Comment