Loading...
SCE
Home
AI Assistant
Ask Anything
Categories
Python
C#
C++
C
Visual Basic
Java
JavaScript
HTML
CSS
SQL
Git
VIEW ALL
Other
Tags
What's Hot
Featured
I'm Feeling Lucky
Latest
SCE
Loading...
Sign Up
Log In
AI Assistant
Loading...
How do you use the NTILE() function to distribute rows into a specified number of groups?
GraceDv
|
Jul 06, 2024
How do you use the APPLY operator to invoke a table-valued function for each row?
IreneSm
|
Jul 14, 2024
How do you create a table with a SPARSE column to optimize storage of NULL values?
HenryPk
|
Jun 17, 2024
How do you use the SQL_VARIANT data type to store different data types in a single column?
NickCrt
|
Aug 03, 2024
How do you use the FOR XML AUTO clause to generate an XML representation of query results?
CarolTh
|
Jul 10, 2024
How can you track the upstream branch of a new local branch?
BobHarris
|
Jun 26, 2024
How do you use the STUFF function to insert a string into another string?
NickCrt
|
Jul 04, 2024
What command shows the commit message, author, and date for a specific commit?
LeoRobs
|
Jun 10, 2024
Write a Python function to find the shortest palindrome that can be formed by adding characters to a string.
NickCrt
|
Aug 07, 2024
Write a Python function to find the longest palindromic substring in a list of strings.
EveClark
|
Aug 21, 2024
How do you use the SET TRANSACTION ISOLATION LEVEL statement to change the isolation level of a transaction?
KarenKg
|
Jul 25, 2024
How do you use the TRY_PARSE function to convert string data to a datetime format?
OliviaWm
|
Jul 15, 2024
How do you use the DATEPART function to extract a part of a date (e.g., year, month)?
NickCrt
|
Jun 10, 2024
JavaScript program that returns the character that appears the most in a string
SceDev
|
Feb 27, 2024
How do you use the CHOOSE function to return values based on an index?
MaryJns
|
Jul 14, 2024
How do you use the CONCAT function to concatenate multiple strings into one?
RoseHrs
|
Jun 10, 2024
How do you use the REPLACE function to replace occurrences of a substring within a string?
LeoRobs
|
Jul 19, 2024
How do you implement a self-referencing foreign key constraint?
RoseHrs
|
Jun 18, 2024
C++ program that find the largest number and counts its occurrences
Samath
|
Jan 20, 2024
How do you use the OVER clause with aggregate functions to calculate cumulative sums?
IreneSm
|
Jun 12, 2024
How do you use the OFFSET clause without the FETCH NEXT clause for advanced pagination techniques?
IreneSm
|
Jul 14, 2024
How do you use the LIKE operator with wildcards to perform pattern matching?
SamPetr
|
Jun 04, 2024
How do you use the CREATE TABLE statement with the MEMORY_OPTIMIZED option to create a memory-optimized table?
RoseHrs
|
Jul 29, 2024
What command is used to list all commits in the current branch that are not in the history of the specified branch?
TinaGrn
|
Jun 20, 2024
Java program that determine whether a inputted character is a vowel or consonant
Samath
|
May 08, 2021
How do you perform a case-insensitive search in SQL?
MaryJns
|
Jul 08, 2024
How do you use the STRING_AGG function to concatenate multiple rows into a single string?
EveClark
|
Jun 12, 2024
How do you use the TRY...CATCH block to handle errors in a SQL Server transaction?
JackBrn
|
Jul 16, 2024
Java program that prints a greeting in Spanish, French and English
Samath
|
Jan 08, 2021
How can you show the hash of a specific Git object?
BobHarris
|
Jun 21, 2024
How do you use the TRUNCATE TABLE statement to quickly remove all rows from a table?
LeoRobs
|
Jul 06, 2024
How do you use the COALESCE function with multiple columns to handle NULL values?
JackBrn
|
Jun 06, 2024
What command is used to show the contents of a specific file at a specific commit?
IreneSm
|
Jun 08, 2024
Java program that read a sequence of integer inputs and print the smallest and largest of the inputs
Samath
|
Apr 03, 2022
How do you use the CREATE VIEW statement to create a view with an INSTEAD OF trigger?
LeoRobs
|
Jun 10, 2024
How do you write a query to find all employees who have the same job title as their managers?
AliceWk
|
Jun 07, 2024
Write a Python function to find the minimum element in a rotated sorted list.
FrankMl
|
Aug 12, 2024
How do you create a recursive CTE to generate a series of numbers?
AliceWk
|
Jun 20, 2024
How do you use the SCOPE_IDENTITY function to retrieve the last inserted identity value?
QuinnLw
|
Jul 06, 2024