MySQL UNION Operator The UNION operator is used to combine the result-set of two or more SELECT statements. Each SELECT statement within UNION must have the same number of columns The columns must also have similar data types The columns in each SELECT statement must also be in the same order Example: Basic Query: SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2; … Read more
C program to print happy holi Here is the simple program written in c to Print Happy Holi. #include<stdio.h> #include<conio.h> void main() { printf(“HAPPY HOLI “); getch(); }
MySQL table join JOIN clause is used to combine rows from two or more tables, based on a related column between them. Different Types of SQL JOINs Here are the different types of the JOINs in SQL: (INNER) JOIN: Returns records that have matching values in both tables LEFT (OUTER) JOIN: Return all records from … Read more
MySQL LIKE Operator The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are % wildcards often used in conjunction with the LIKE operator: % – The percent sign represents zero, one, or multiple characters _ – The underscore represents a single character SELECT column1, column2, … Read more
MySQL SUM function The SUM() function returns the total sum of a numeric column. The SUM() function is an aggregate function that allows you to calculate the sum of a set of values or an expression. Syntax for SUM function would be as below: SELECT SUM(column_name) FROM table_name WHERE condition; You can also use distinct value while sum function SELECT SUM(distinct column_name) FROM table_name WHERE condition; If … Read more
Jio number tele verification from Adhar number Sometimes you do’nt receive tele verification code via SMS, So you can can also verify from Adhar card. Here is the steps to tele verification from Adhar card Call on 1977 from jio number which has to be tele verify. Enter any 5 digit number when asked … Read more
PHP mysql select average program example PHP MySQL code to to calculate average. <!doctype html> <html lang=”en”> <head> <meta charset=”utf-8″> <meta name=”viewport” content=”width=device-width, initial-scale=1″> <title>Example of avg function in php MySQL – Blog.eduguru.in</title> <meta name=”description” content=”Example of avg function in php MySQL”> <link rel=”stylesheet” href=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css”> </head> <body> <div class=”container”> <div class=”row”> <div class=”col-md-12″> <h2>Example … Read more
MySQL AVG() function AVG function to calculate the average value of a set of values or an expression. The AVG() function returns the average value of a numeric column. If the function does not find a matching row, it returns NULL The DISTINCT option can also be used to return the average of the distinct values of expr. … Read more
MySQL count function The COUNT() function returns the number of rows that matches a specified criteria. COUNT function to count the number rows in a table. The return type of the COUNT function is BIGINT. The COUNT function will return zero if there was no matching row found. The COUNT(*) function returns the number of rows in a … Read more
MySQL MIN() and MAX() Functions The MIN() function returns the smallest value of the selected column and the MAX() function returns the largest value of the selected column. MIN() Syntax SELECT MIN(column_name) FROM table_name WHERE condition; MAX() Syntax SELECT MAX(column_name) FROM table_name WHERE condition;