sherinangel

what is union clause in SQL ?

Once WordArt has been inserted, you can change its appearance to another style or customize its appearance and effects.

Select the WordArt object by clicking its border or by selecting all the text inside the object.
Use the options in the WordArt Styles group, on the Format tab in the Drawing Tools ribbon group, to change the formatting options…[Read more]

The SIGN function in Excel is a Maths/Trig function that gives us this result. The SIGN function returns the sign (-1, 0, or +1) of the supplied numerical argument. The SIGN formula in Excel can be used by typing the keyword: =SIGN( and providing the number as input.

For example, suppose we have a dataset of sales of a product for two years in…[Read more]

Excel Charts
Charts are visual representations of data used to make it more understandable.

Commonly used charts are:

Pie chart
Column chart
Line chart

Microsoft Office, or simply Office, is a discontinued family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas. Initially a marketing term for an office suite (bundled set of productivity applications), the first version of Office contained…[Read more]

// C Program to illustrate the 3d array
#include <stdio.h>

int main()
{

// 3D array declaration
int arr[2][2][2] = { 10, 20, 30, 40, 50, 60 };

// printing elements
for (int i = 0; i < 2; i++) {
for (int j = 0; j < 2; j++) {
for (int k = 0; k < 2; k++) {
printf(“%d “, arr[i][j][k]);…[Read more]

// C Program to illustrate 2d array
#include <stdio.h>

int main()
{

// declaring and initializing 2d array
int arr[2][3] = { 10, 20, 30, 40, 50, 60 };

printf(“2D Array:n”);
// printing 2d array
for (int i = 0; i < 2; i++) {
for (int j = 0; j < 3; j++) {
printf(“%d “,arr[i][j]);
}…[Read more]

/ C Program to demonstrate the use of array
#include <stdio.h>

int main()
{
// array declaration and initialization
int arr[5] = { 10, 20, 30, 40, 50 };

// modifying element at index 2
arr[2] = 100;

// traversing array using for loop
printf(“Elements in Array: “);
for (int i = 0; i < 5; i++) {
printf(“%d “,…[Read more]

#include<stdio.h>
int main()
{
FILE* fp;
char ch;
fp-fopen(“test1.txt”, “r”);
if (fp == NULL)
{
printf(“Unable to open file
”);
system(“PAUSE”);
Return 0;
}
do
{
ch=getc(fp);
printf(“%c”,ch);
}
while(ch !=EOF);
fclose(fp);…[Read more]

/ C program to check if a number is
// even or not using goto statement
#include <stdio.h>

// function to check even or not
void checkEvenOrNot(int num)
{
if (num % 2 == 0)
// jump to even
goto even;
else
// jump to odd
goto odd;

even:
printf(“%d is even”, num);
// return if even…[Read more]

#include <stdio.h>

int main () {

/* local variable definition */
char grade = ‘B’;

switch(grade) {
case ‘A’ :
printf(“Excellent!n” );
break;
case ‘B’ :
case ‘C’ :
printf(“Well donen” );
break;
case ‘D’ :
printf(“You passedn” );
break;
case ‘F’ :…[Read more]

do-while Statement (C)
Article
01/25/2023
7 contributors
The do-while statement lets you repeat a statement or compound statement until a specified expression becomes false.

Syntax
iteration-statement:  do statement while ( expression ) ;

The expression in a do-while statement is evaluated after the body of the loop is executed. Therefore, the b…[Read more]

#include <stdio.h>

int main () {

/* local variable definition */
int a = 10;

/* while loop execution */
while( a < 20 ) {
printf(“value of a: %dn”, a);
a++;
}

return 0;
}

// Print numbers from 1 to 10
#include <stdio.h>

int main() {
int i;

for (i = 1; i < 11; ++i)
{
printf(“%d “, i);
}
return 0;
}

// Check whether an integer is odd or even

#include <stdio.h>
int main() {
int number;
printf(“Enter an integer: “);
scanf(“%d”, &amp;number);

// True if the remainder is 0
if (number%2 == 0) {
printf(“%d is an even integer.”,number);
}
else {
printf(“%d is an odd integer.”,number);
}

return…

Other Operators
Apart from the above operators, there are some other operators available in C used to perform some specific tasks. Some of them are discussed here:

i. sizeof operator
sizeof is much used in the C programming language.
It is a compile-time unary operator which can be used to compute the size of its operand.
The result of sizeof…[Read more]

Assignment Operators in C
Assignment operators are used to assign value to a variable. The left side operand of the assignment operator is a variable and the right side operand of the assignment operator is a value. The value on the right side must be of the same data type as the variable on the left side otherwise the compiler will raise an…[Read more]

Bitwise Operators in C
The Bitwise operators are used to perform bit-level operations on the operands. The operators are first converted to bit-level and then the calculation is performed on the operands. Mathematical operations such as addition, subtraction, multiplication, etc. can be performed at the bit level for faster processing. For…[Read more]