8.SQL Query to Count odd and even digits in a number
Author: neptune | 24th-Apr-2022
Count odd and even digits in a number
Problem Statement : Write a query that counts odd and even digits in a number.
Sample format is described as follows:
Example 1.
Input : 123456
Output : Odd digits = 3
Even digits = 3
Example 2.
Input : 6543
Output : Odd digits = 2
Even digits = 2
Solution :
For this challenge, we must:
We will iterate the number and check the digits one by one, if it is odd or even.
Query :
DECLARE
num NUMBER := 123456;
len VARCHAR2(20);
count1 NUMBER(5) :=0;
count2 NUMBER(5) := 0;
BEGIN
FOR i IN 1..Length(num)
LOOP
len := Substr(num, i, 1);
IF mod(len, 2) != 0 THEN
count1 := count1+1;
ELSE
count2 :=count2+1;
END IF;
END LOOP;
dbms_output.Put_line('Odd Digits: ' || cnt1);
dbms_output.Put_line('Even Digits: ' || cnt2);
END;
Output:
Odd Digits: 3
Even Digits: 3
Hope you learn something !!!
If you have any questions let me know in the comment section.
#JavaScript #Python #Hackerrank #Motivation #AI #React.js #Interview #Testing #SQL #Selenium #LeetCode #Problem Solving #Machine learning #IT #API #Java #GPT #AWS #Algorithms #Github #Projects #Jobs #Django #Microservice #Certifications #Node.js #TCS #Google #Story #Pip #Data Science #Postman #Health #Twitter #Elon Musk
1. Basic SQL Select Query of Hacker Rank.Author: neptune | 20th-Apr-2022
#SQL #Hackerrank
Problem Statement : Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA...
Modified 0-1 knapsack problem | Frsco Play HackerrankAuthor: neptune | 05th-Nov-2023
#Hackerrank #Problem Solving
An automobile mechanic wants to buy a set of spare parts from a manufacturing unit. Goal is to maximise the amount of money the mechanic can earn...
AngularJS - Know Tech Frameworks | Fresco PlayAuthor: neptune | 05th-Nov-2023
#Hackerrank #Problem Solving
Build an application that displays the framework details using AngularJS routing. We will build an application that displays the Tech Frontend and Backend frameworks...
30+ SQL Interview QuestionsAuthor: neptune | 05th-Jan-2023
#Interview #SQL
Data Definition Language (DDL) – It allows end-users to CREATE, ALTER, and DELETE database objects...
PySpark Milestone Black Friday Sales Data | Fresco Play HackerrankAuthor: neptune | 05th-Nov-2023
#Data Science #Hackerrank
Welcome to the Spark Challenge. You are provided with the Black Friday sales data and we as a big data developer needs to analyze and fetch the required data...
Python - Number Based Problem | HackerrankAuthor: neptune | 17th-Aug-2023
#Hackerrank #Problem Solving
Determine whether the number in descending order is a prime or not. If the number is a prime, then print "Sorted Number is a prime number," otherwise, print "Sorted Number is not a prime number."..
View More