#### Remove Element

Given an integer array nums and an integer val, remove all occurrences of val in nums in-place. The relative order of the elements may be changed. Since it is impossible…

Skip to content
# SkyCode

#### Remove Element

#### Search Insert Position

#### Length of Last Word

#### Plus One – C#

#### Valid Parentheses

#### Longest Common Prefix

#### SQL Joins

#### Day 8: C# Casting and type conversions

#### SQL query to find the third highest salary in the company

#### Find Pivot Index

## You Missed

VICKY CHHETRI

Given an integer array nums and an integer val, remove all occurrences of val in nums in-place. The relative order of the elements may be changed. Since it is impossible…

Given a sorted array of distinct integers and a target value, return the index if the target is found. If not, return the index where it would be if it…

Given a string s consisting of words and spaces, return the length of the last word in the string. A word is a maximal substring consisting of non-space characters only.…

You are given a large integer represented as an integer array digits, where each digits is the ith digit of the integer. The digits are ordered from most significant to…

Given a string s containing just the characters '(', ')', '{', '}', '', determine if the input string is valid. An input string is valid if: Open brackets must be…

Write a function to find the longest common prefix string amongst an array of strings. If there is no common prefix, return an empty string Example 1: Input: strs =…

INNER JOIN: is used when retrieving data from multiple tables and will return only matching data. LEFT OUTER JOIN: is used when retrieving data from multiple tables and will return…

C# is statically-typed at compile time, after a variable is declared, it cannot be declared again or assigned a value of another type unless that type is implicitly convertible to…

The question is a bit confusing for the developer, Interviewer Always asks this question in SQL. The most straightforward way that should work in any database is to do the…

Example 1: Input: nums = Output: 3 Explanation: The pivot index is 3. Left sum = nums + nums + nums = 1 + 7 + 3 = 11 Right…