Home

What are the types of SQL Queries ?

Published on 16-Dec-2021 16:23:22
We have four types of SQL Queries: DDL (Data Definition Language): the creation of objects DML (Data Manipulation Language): manipulation of data DCL (Data Control Language): assignment and removal of permissions TCL (Transaction Control Language): saving and restoring changes to a database Let’s look at the different commands under DDL: Command Description CREATE Create objects in the database ALTER A... Read More

Write C Program to Find Factorial of Number Using Recursion

Published on 16-Dec-2021 16:13:59
#include stdio.h> #include conio.h> int fact(int); int main() { int factorial, num; printf("Enter the value of num :"); scanf("%d", &num); factorial = fact(num); printf("Factorial is %d", factorial); return (0); } int fact(int n) { if (n == 0) { return (1); } return (n * fact(n - 1)); } ... Read More

How to Solve Second Order Quadratic Equation Using C Program

Published on 16-Dec-2021 16:09:33
Program : To obtain solution of second order quadratic equation #include <stdio.h> #include <math.h> int main() { float a, b, c; float desc, root1, root2; printf("\nEnter the Values of a : "); scanf("%f", &a); printf("\nEnter the Values of b : "); scanf("%f", &b); printf("\nEnter the Values of c : "); scanf("%f", &c); desc = sqrt(b * b - 4 * a * c); root1 = (-b + desc) /... Read More

How to calculate sum of 5 subjects and find percentage Using C Program

Published on 16-Dec-2021 16:02:43
C Program to calculate sum of 5 subjects and find percentage #include <stdio.h> int main() { int s1, s2, s3, s4, s5, sum, total = 500; float per; printf("\nEnter marks of 5 subjects : "); scanf("%d %d %d %d %d", &s1, &s2, &s3, &s4, &s5); sum = s1 + s2 + s3 + s4 + s5; printf("\nSum : %d", sum); per = (sum * 100) / total; printf("\nPercentage : %f", per); return (0); } ... Read More

How to reverse a given number using C

Published on 16-Dec-2021 15:56:34
#include <stdio.h> int main() { int num, rem, rev = 0; printf("\nEnter any no to be reversed : "); scanf("%d", &num); while (num >= 1) { rem = num % 10; rev = rev * 10 + rem; num = num / 10; } printf("\nReversed Number : %d", rev); return (0); } Output : Enter any no to be reversed : 123 Reversed Number : 321 ... Read More

How to calculate gross salary of a person using C Program

Published on 16-Dec-2021 15:48:12
#include <stdio.h> int main() { int gross_salary, basic, da, ta; printf("Enter basic salary : "); scanf("%d", &basic); da = (10 * basic) / 100; ta = (12 * basic) / 100; gross_salary = basic + da + ta; printf("\nGross salary : %d", gross_salary); return (0); } Output : Enter basic Salary : 1000 Gross Salart : 1220 ... Read More

How to reads customer number and power consumed and prints amount to be paid using C

Published on 16-Dec-2021 15:41:24
An electric power distribution company charges its domestic consumers as follows Consumption Rate of Units Charge ------------------------------------ 0-200 Rs.0.50 per unit 201-400 Rs.100 plus Rs.0.65 per unit excess 200 401-600 Rs.230 plus Rs.0.80 per unit excess of 400. ------------------------------------ Write a C program that reads the customer number and power consumed an... Read More

How to read the values of x, y and z and print the results expressions in one line using C Program

Published on 16-Dec-2021 15:31:37
Problem Statement : Write a program to read the values of x, y and z and print the results of the following expressions in one line. (x+y+z) / (x-y-z) (x+y+z) / 3 (x+y) * (x-y) * (y-z) Program : #include<stdio.h> #include<conio.h> void main() { int x, y, z; float a, b, c; clrscr(); printf("\nEnter the values of x,y and z : "); scanf("%d %d %d", &x, &y, &z); a = (x + y + z) / (x - y - z... Read More

How can I see all tables in SQL?

Published on 14-Dec-2021 17:13:39
Different database management systems have different queries to see all the tables. To see all the tables in MYSQL, we would have to use this query: show tables; This is how we can see all tables in ORACLE: SELECT table_name FROM User_tables; This is how we can extract all tables in SQL Server: SELECT * FROM Information_schema.tables; ... Read More