👩💻 75+ SQL Practice Questions
➤ Oracle
➤ MySQL
➤ SQL Server
➤ PostgreSQL
➤ SQLite
⇩
➤ Oracle
➤ MySQL
➤ SQL Server
➤ PostgreSQL
➤ SQLite
⇩
➊ Date Related Operations
➀ 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.
➋ String Related Operations
➀ Convert a string to upper case.
➁ Convert a string to lower case.
➂ Convert characters of each word of a string to upper case.
➃ Find the given number of left most characters.
➄ Find the given number of right most characters.
➀ Convert a string to upper case.
➁ Convert a string to lower case.
➂ Convert characters of each word of a string to upper case.
➃ Find the given number of left most characters.
➄ Find the given number of right most 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.
➌ Number Related Operations
➀ 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.
➀➂ 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
➀➃ 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
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 Flow Operations
➀ 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)
👩💻 Practice more
Hey 👋
I am a Tech Writer, Educator, and Mentor from India 🇮🇳, here sharing
✅ Tutorials
✅ Tricks
✅ Career Tips
✅ Cheat Sheets
✅ Practice Questions
✅ Project Ideas
on
➠ Web Development
➠ Data Structures and Algorithms
➠ Databases
Thanks for reading. 🙏
I am a Tech Writer, Educator, and Mentor from India 🇮🇳, here sharing
✅ Tutorials
✅ Tricks
✅ Career Tips
✅ Cheat Sheets
✅ Practice Questions
✅ Project Ideas
on
➠ Web Development
➠ Data Structures and Algorithms
➠ Databases
Thanks for reading. 🙏
Loading suggestions...