ROW_NUMBER, RANK and DENSE_RANK excercise
Exercise
Correct!
DECLARE @Table TABLE (
Col_Value varchar(2)
)
INSERT INTO @Table (Col_Value)
VALUES ('A'),('A'),('A'),('B'),('B'),('C'),('C');
SELECT Col_Value,
code_here AS 'RowID'
FROM @Table;
DECLARE @Table TABLE (
Col_Value varchar(2)
)
INSERT INTO @Table (Col_Value)
VALUES ('A'),('A'),('A'),('B'),('B'),('C'),('C');
SELECT Col_Value,
ROW_NUMBER() OVER (ORDER BY Col_Value) AS 'RowID'
FROM @Table;
assert(line7 == l7);
function rpls(str){
return str.toLowerCase().replace(/'/g,'').replace(/ /g, '');
}
var l7 = rpls("ROW_NUMBER() OVER (ORDER BY Col_Value) AS 'RowID'");
Exercise
Correct!
DECLARE @Table TABLE (
Col_Value varchar(2)
)
INSERT INTO @Table (Col_Value)
VALUES ('A'),('A'),('A'),('B'),('B'),('C'),('C');
SELECT Col_Value,
code_here AS 'RowID'
FROM @Table;
DECLARE @Table TABLE (
Col_Value varchar(2)
)
INSERT INTO @Table (Col_Value)
VALUES ('A'),('A'),('A'),('B'),('B'),('C'),('C');
SELECT Col_Value,
RANK() OVER (ORDER BY Col_Value) AS 'RowID'
FROM @Table;
assert(line7 == l7);
function rpls(str){
return str.toLowerCase().replace(/'/g,'').replace(/ /g, '');
}
var l7 = rpls("RANK() OVER (ORDER BY Col_Value) AS 'RowID'");
Exercise
Correct!
DECLARE @Table TABLE (
Col_Value varchar(2)
)
INSERT INTO @Table (Col_Value)
VALUES ('A'),('A'),('A'),('B'),('B'),('C'),('C');
SELECT Col_Value,
code_here AS 'RowID'
FROM @Table;
DECLARE @Table TABLE (
Col_Value varchar(2)
)
INSERT INTO @Table (Col_Value)
VALUES ('A'),('A'),('A'),('B'),('B'),('C'),('C');
SELECT Col_Value,
DENSE_RANK() OVER (ORDER BY Col_Value) AS 'RowID'
FROM @Table;
assert(line7 == l7);
function rpls(str){
return str.toLowerCase().replace(/'/g,'').replace(/ /g, '');
}
var l7 = rpls("DENSE_RANK() OVER (ORDER BY Col_Value) AS 'RowID'");