👩💻 75+ SQL Practice Questions
➤ Oracle
➤ MySQL
➤ MariaDB
➤ SQL Server
➤ PostgreSQL
➤ SQLite
⇩
➤ Oracle
➤ MySQL
➤ MariaDB
➤ SQL Server
➤ PostgreSQL
➤ SQLite
⇩
Questions covered:
Built-in functions related to
➊ Strings
➋ Dates and Times
➌ Numbers
➍ Control Flows
Built-in functions related to
➊ Strings
➋ Dates and Times
➌ Numbers
➍ Control Flows
➊ Strings
➀ Convert a string to uppercase.
➁ Convert a string to lowercase.
➂ Convert characters of each word of a string to upper case.
➃ Find the given number of the leftmost characters.
➄ Find the given number of the rightmost characters.
➀ Convert a string to uppercase.
➁ Convert a string to lowercase.
➂ Convert characters of each word of a string to upper case.
➃ Find the given number of the leftmost characters.
➄ Find the given number of the rightmost characters.
➅ Find the first occurrence of a string in another string.
➆ Find the first occurrence of a string in another string after a position.
➇ Fill in some characters at the beginning of a string.
➈ Fill in some characters at the end of a string.
➆ Find the first occurrence of a string in another string after a position.
➇ Fill in some characters at the beginning of a string.
➈ Fill in some characters at the end of a string.
➉ Remove whitespace from the beginning of a string.
➀➀ Remove whitespace from the end of a string.
➀➁ Remove whitespace from both sides of a string.
➀➂ Repeat a string for the given time.
➀➃ Reverse a string.
➀➄ Compare 2 strings.
➀➀ Remove whitespace from the end of a string.
➀➁ Remove whitespace from both sides of a string.
➀➂ Repeat a string for the given time.
➀➃ Reverse a string.
➀➄ Compare 2 strings.
➀➅ Replace the occurrences of a string in another string with some value.
➀➆ Add a string at a specific position on a string.
➀➇ Concatenate multiple strings with a separator.
➀➈ Convert a number to a character.
➀➆ Add a string at a specific position on a string.
➀➇ Concatenate multiple strings with a separator.
➀➈ Convert a number to a character.
20. Return a string of a given number of space characters.
➁➀ Find the SHA-1 checksum.
➁➁ Find the SHA-2 checksum.
➁➂ Find the MD5 checksum.
➁➀ Find the SHA-1 checksum.
➁➁ Find the SHA-2 checksum.
➁➂ Find the MD5 checksum.
➋ Dates and Times
➀ Find the current timestamp.
➁ Find the current date and time.
➂ Find the current time in the local time zone.
➃ Find the current time in UTC.
➄ Find today's date.
➅ Find tomorrow's date.
➆ Find yesterday's date.
➀ Find the current timestamp.
➁ Find the current date and time.
➂ Find the current time in the local time zone.
➃ Find the current time in UTC.
➄ Find today's date.
➅ Find tomorrow's date.
➆ Find yesterday's date.
➇ Convert a date string to a date value.
➈ Format a date object to a string value
Given a date / time,
➉ Find the day on that date
➀➀ Find the month on that date
➀➁ Find the month name on that date
➀➂ Find the year on that date
➀➃ Find the day of the week on that date
➈ Format a date object to a string value
Given a date / time,
➉ Find the day on that date
➀➀ Find the month on that date
➀➁ Find the month name on that date
➀➂ Find the year on that date
➀➃ Find the day of the week on that date
➀➄ Find the name of the day of the week on that date
➀➅ Find the week of the year on that date
➀➆ Find the hour at that time
➀➇ Find the minutes at that time
➀➈ Find the seconds at that time
20. Given your date of birth, find your age.
➀➅ Find the week of the year on that date
➀➆ Find the hour at that time
➀➇ Find the minutes at that time
➀➈ Find the seconds at that time
20. Given your date of birth, find your age.
➁➀ Given a course completion date, find the remaining days.
➁➁ Given a course will take 75 days to complete after registration, find the expected completion date.
➁➂ A pizza should be delivered in 20 minutes. Find the expected delivery time.
➁➁ Given a course will take 75 days to complete after registration, find the expected completion date.
➁➂ A pizza should be delivered in 20 minutes. Find the expected delivery time.
➌ Numbers
➀ Find the ceiling value of a number.
➁ Find the floor value of a number.
➂ Truncate a number to given decimal places.
➃ Round a number to an integer.
➄ Round a number to given decimal places.
➅ Find the sign of a number.
➀ Find the ceiling value of a number.
➁ Find the floor value of a number.
➂ Truncate a number to given decimal places.
➃ Round a number to an integer.
➄ Round a number to given decimal places.
➅ Find the sign of a number.
➆ Find the absolute value of a number
➇ Convert a decimal to a binary.
➈ Convert a decimal to an octal.
➉ Convert a decimal to a hexadecimal.
➀➀ Convert a binary to a decimal.
➀➁ Convert an octal to a decimal.
➀➂ Convert a hexadecimal to a decimal.
➇ Convert a decimal to a binary.
➈ Convert a decimal to an octal.
➉ Convert a decimal to a hexadecimal.
➀➀ Convert a binary to a decimal.
➀➁ Convert an octal to a decimal.
➀➂ Convert a hexadecimal to a decimal.
➀➃ Convert a binary to an octal
➀➄ Convert a binary to hexadecimal
➀➅ Convert an octal to a binary.
➀➆ Convert an octal to a hexadecimal.
➀➇ Convert a hexadecimal to a binary.
➀➈ Convert a hexadecimal to an octal.
➀➄ Convert a binary to hexadecimal
➀➅ Convert an octal to a binary.
➀➆ Convert an octal to a hexadecimal.
➀➇ Convert a hexadecimal to a binary.
➀➈ Convert a hexadecimal to an octal.
20. Convert a radian to a degree.
➁➀ Convert a degree to a radian.
➁➁ Find trigonometric function values.
➁➂ Raise a number to the power of another number.
➁➃ Find the modulus/remainder.
➁➄ Find the 32-bit cyclic redundancy check value (CRC32).
➁➀ Convert a degree to a radian.
➁➁ Find trigonometric function values.
➁➂ Raise a number to the power of another number.
➁➃ Find the modulus/remainder.
➁➄ Find the 32-bit cyclic redundancy check value (CRC32).
➍ Control Flows
➀ Return another value if a given value is NULL
➁ Return the first non-NULL value in a given list of values.
➂ Check if the given value is NULL (using a function)
➃ Return NULL if 2 values are equal (using a function)
➀ Return another value if a given value is NULL
➁ Return the first non-NULL value in a given list of values.
➂ Check if the given value is NULL (using a function)
➃ Return NULL if 2 values are equal (using a function)
👩💻 Where to practice?
You can easily practice these online using these free compilers:
➤ OneCompiler
➤ MyCompiler
➤ Programiz
➤ JDoodle
➤ W3Schools
➤ Oracle Live SQL
You can easily practice these online using these free compilers:
➤ OneCompiler
➤ MyCompiler
➤ Programiz
➤ JDoodle
➤ W3Schools
➤ Oracle Live SQL
Hey 👋
I am a Tech Writer and Educator from India 🇮🇳, here sharing
✰ Tutorials
✰ Tricks
✰ Career Tips
✰ Cheat Sheets
✰ Practice Questions
✰ Roadmaps
on
➠ Web Development
➠ Data Structures and Algorithms
➠ Databases
Thanks for reading. 🙏
I am a Tech Writer and Educator from India 🇮🇳, here sharing
✰ Tutorials
✰ Tricks
✰ Career Tips
✰ Cheat Sheets
✰ Practice Questions
✰ Roadmaps
on
➠ Web Development
➠ Data Structures and Algorithms
➠ Databases
Thanks for reading. 🙏
جاري تحميل الاقتراحات...