Missing Test Case #8000
Description
Your LeetCode username
GeeteshSood
Category of the bug
- Question
- Solution
- Language
- [ x] Missing Test Cases
Description of the bug
This type of test case is not present .
{"headers": {"Employee": ["id", "salary"]}, "argument": 2, "rows": {"Employee": [[1, 100], [2, 100], [3, 300] , [4, 300]]}}
Code you used for Submit/Run operation
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
RETURN (
select salary from Employee e1 where N-1 = (select count(salary) from Employee e2 where e1.salary < e2.salary)
);
END
#### Language used for code
<!-- C++ -->
mysql
#### Expected behavior
<!-- A clear and concise description of what you expected to happen contrasts with what happened. -->
In the case of multiple duplicate salaries, my code is getting failed.
But my solution is getting failed on the last test case only (passed 13 out of 14) but it is difficult to understand that test case as it comprises of multiple rows.
{"headers": {"Employee": ["id", "salary"]}, "argument": 88, "rows": {"Employee": [[12, 761], [6, 1037], [87, 38], [1, 786], [39, 1762], [65, 133], [25, 2529], [96, 403], [8, 4333], [11, 3164], [5, 831], [18, 3579], [66, 4778], [26, 4826], [82, 4957], [63, 1288], [64, 2711], [73, 1842], [2, 2627], [78, 1908], [22, 4667], [77, 199], [69, 576], [32, 2638], [79, 510], [23, 622], [43, 2491], [44, 4435], [28, 4552], [86, 4646], [57, 451], [13, 1852], [62, 2835], [72, 544], [37, 2896], [89, 4699], [71, 220], [46, 2333], [95, 2261], [48, 3210], [17, 398], [20, 57], [74, 176], [54, 4272], [35, 2172], [84, 4686], [42, 2595], [76, 3631], [45, 4022], [68, 3248], [40, 571], [14, 4094], [51, 3272], [97, 2057], [30, 2505], [88, 3805], [55, 4926], [81, 3423], [7, 811], [52, 4664], [33, 1842], [41, 4645], [50, 1490], [24, 3361], [59, 4504], [99, 805], [67, 4561], [61, 4641], [38, 2542], [94, 4361], [15, 1652], [70, 1903], [10, 2109], [49, 1428], [29, 558], [60, 708], [3, 1717], [0, 3162], [75, 1450], [83, 2333], [47, 455], [9, 2360], [56, 1570], [80, 1677], [27, 508], [21, 3994], [85, 2276], [91, 1606], [90, 2269], [58, 1954], [19, 774], [4, 655], [92, 3274], [16, 333], [36, 1744], [53, 2262], [93, 3887], [31, 3521], [34, 1415], [98, 2490]]}}
It is very difficult to understand where my code is getting wrong by checking on this long test case.
Instead of it, you can add my test case which is easier to understand and will be good for other users also.
{"headers": {"Employee": ["id", "salary"]}, "argument": 2, "rows": {"Employee": [[1, 100], [2, 100], [3, 300] , [4, 300]]}}
#### Screenshots
<!-- If applicable, add screenshots to explain your issue. -->
#### Additional context
<!-- Add any other additional context about the bug. -->