Count Rows Having Three or More Values in MySQL Table

Rama Giri
Updated on 30-Jul-2019 22:30:26

155 Views

Let us first create a table −mysql> create table DemoTable    -> (    -> UserId int    -> ); Query OK, 0 rows affected (0.48 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(10); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(20); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values(30); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(10); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(10); Query OK, 1 row affected (0.09 sec) ... Read More

C++ Program for Sum of Squares of First N Natural Numbers

Arnab Chakraborty
Updated on 30-Jul-2019 22:30:26

651 Views

In this problem we will see how we can get the sum of squares of first n natural numbers. Here we are using one for loop, that runs from 1 to n. In each step we are calculating square of the term and then add it to the sum. This program takes O(n) time to complete. But if we want to solve this in O(1) or constant time, we can use this series formula −AlgorithmsquareNNatural(n)begin    sum := 0    for i in range 1 to n, do       sum := sum + i^2    done    return ... Read More

HTML DOM Length Property

AmitDiwan
Updated on 30-Jul-2019 22:30:26

196 Views

The HTML DOM length property returns a number corresponding to the nodes in node list object.SyntaxFollowing is the syntax −Returning number of nodes in nodeList Object.nodeList.lengthExampleLet us see an example for HTML DOM length property − Live Demo HTML DOM length    form {       width:70%;       margin: 0 auto;       text-align: center;    }    * {       padding: 2px;       margin:5px;    }    input[type="button"] {       border-radius: 10px;    }    ul{       width: 30%;       margin: 0 auto; ... Read More

Difference Between P and X in C/C++

Nishtha Thakur
Updated on 30-Jul-2019 22:30:26

10K+ Views

Here we will see what are the differences between %p and %x in C or C++. The %p is used to print the pointer value, and %x is used to print hexadecimal values. Though pointers can also be displayed using %u, or %x. If we want to print some value using %p and %x then we will not feel any major differences. The only difference that can be noticed is that the %p will print some leading zeros, but %x doesn’t.Example#include main() {    int x = 59;    printf("Value using %%p: %p", x);    printf("Value using %%x: %x", x); ... Read More

Levenshtein Distance Computing Algorithm in C++

Nishtha Thakur
Updated on 30-Jul-2019 22:30:26

4K+ Views

The Levenshtein distance between two strings means the minimum number of edits needed to transform one string into the other, with the edit operations i.e; insertion, deletion, or substitution of a single character.For example: The Levenshtein Distance between cat and mat is 1 −cat mat(substitution of ‘c’ with ‘m’)Here is a C++ Program to implement Levenshtein Distance computing algorithm.AlgorithmsBegin    Take the strings as input and also find their length.    For i = 0 to l1       dist[0][i] = i    For j = 0 to l2       dist[j][0] = j    For j=1 to l1 ... Read More

Clear Android Notification After a Few Seconds

Smita Kapse
Updated on 30-Jul-2019 22:30:26

707 Views

This example demonstrate about How to clear an Android notification after a few seconds.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml.     Step 3 − Add the following code to src/MainActivity.javapackage app.tutorialspoint.com.notifyme ; import android.app.NotificationChannel ; import android.app.NotificationManager ; import android.app.PendingIntent ; import android.content.Context ; import android.content.Intent ; import android.os.Handler ; import android.support.v4.app.NotificationCompat ; import android.support.v7.app.AppCompatActivity ; import android.os.Bundle ; import android.view.View ; import android.widget.Button ; public class MainActivity extends AppCompatActivity {   ... Read More

Resize and Position a JFrame in Java

Arjun Thakur
Updated on 30-Jul-2019 22:30:26

869 Views

To resize and position JFrame, use the Dimensions class. Here, we have set the bounds for the frame −int width = 500; int height = 400; Dimension size = Toolkit.getDefaultToolkit().getScreenSize(); frame.setBounds((int) size.getWidth() - width, 0, width, height);The following is an example to resize and poisiton a frame −Examplepackage my; import java.awt.Dimension; import java.awt.GridLayout; import java.awt.Toolkit; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JPasswordField; import javax.swing.JTextField; import javax.swing.SwingConstants; public class SwingDemo {    public static void main(String[] args) throws Exception {       JFrame.setDefaultLookAndFeelDecorated(true);       JFrame frame = new JFrame("Register!");       JLabel label1, label2, label3;       ... Read More

Benefits of Passing by Pointer vs. Passing by Reference in C++

Nishtha Thakur
Updated on 30-Jul-2019 22:30:26

537 Views

A pointer can receive a null parameter whereas a reference can’t. You can only use pointer if you want to pass “no object”.Explicitly passing by pointer allow us to see the whether the object is passes by reference or value at call site.These are simple example of passing by pointer and passing by reference −Passing by pointerExample Live Demo#include using namespace std; void swap(int* a, int* b) {    int c = *a;    *a= *b;    *b = c; } int main() {    int m =7 , n = 6;    cout

Answer Incoming Call Programmatically in iOS

karthikeya Boyini
Updated on 30-Jul-2019 22:30:26

511 Views

Apple iPhone SDK doesn’t allow this feature. If you really wish to achieve it you can use some private api such as CTCallAnswer(call);This will result in your app store rejection.

HTML DOM LI Object

AmitDiwan
Updated on 30-Jul-2019 22:30:26

169 Views

The HTML DOM Li Object in HTML represents the element.SyntaxFollowing is the syntax −Creating a elementvar liObject = document.createElement(“LI”)PropertiesHere, “LiObject” can have the following properties −PropertyDescriptionvalueIt returns/sets the value of the value attribute of a elementExampleLet us see an example for Li value property − Live Demo HTML DOM value    form {       width:70%;       margin: 0 auto;       text-align: center;    }    * {       padding: 2px;       margin:5px;    }    input[type="button"] {       border-radius: 10px;    }    ol{ ... Read More

Advertisements