CREATE table #yourtable ([Id] int, [Nama] varchar(6), [Ta...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness

Q&A for physical fitness professionals, athletes, trainers, and those providing health-related needs

CREATE table #yourtable
    ([Id] int, [Nama] varchar(6), [Tahap] varchar(13), [Nilai] int)
;
    
INSERT INTO #yourtable
    ([Id], [Nama], [Tahap], [Nilai])
VALUES
    (1, 'John', '0', 5),
    (2, 'John', '1', 2),
    (3, 'John', '2', 3),
    (4, 'Fork', '0', 4),
    (5, 'Fork', '1', 1)
;


select Id, Nama, Tahap, Nilai
from
(
  select Id, Nama, Tahap, Nilai
  from #yourtable
) d

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results