H.K.I.T
Login     Free Signup

SELECT - extracts data from a database UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database
CREATE DATABASE - creates a new database
ALTER DATABASE - modifies a database CREATE TABLE - creates a new table
ALTER TABLE - modifies a table
DROP TABLE - deletes a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index

SELECT Syntax SELECT column1, column2, ... FROM table_name;

Here, column1, column2, ... are the field names of the table you want to select data from. If you want to select all the fields available in the table, use the following syntax:

SELECT * FROM table_name;

SELECT Columns Example-
The following SQL statement selects the "CustomerName", "City", and "Country" columns from the "Customers" table: Example-

SELECT CustomerName, City, Country FROM Customers;

SELECT DISTINCT Syntax SELECT DISTINCT column1, column2, ... FROM table_name;
SELECT DISTINCT Examples
The following SQL statement selects only the DISTINCT values from the "Country" column in the "Customers" table:
Example
SELECT DISTINCT Country FROM Customers;

The following SQL statement counts and returns the number of different (distinct) countries in the "Customers" table:
Example

SELECT COUNT(DISTINCT Country) FROM Customers;

The WHERE clause is used to filter records.
It is used to extract only those records that fulfill a specified condition.

WHERE Syntax SELECT column1, column2, ... FROM table_name WHERE condition;

Note: The WHERE clause is not only used in SELECT statements, it is also used in UPDATE, DELETE, etc.!

Sample Solution C Code:
#include < stdio.h >
int main() {
int num;
printf("Enter an integer: ");
scanf("%d", &num);
// true if num is perfectly divisible by 2
if(num % 2 == 0)
printf("%d is even.", num);
else
printf("%d is odd.", num);
return 0;
}
Output
Enter an integer: 7
7 is odd.

More >
 

Sample Solution C Code:
#include
int main()
{
int n1, n2, n3;
printf("Enter three numbers: ");
scanf("%d %d %d", &n1, &n2, &n3);
if (n1 >= n2) {
if (n2 >= n3)
printf("%d is the largest number.", n1);
else
printf("%d is the largest number.", n3);
}
else {
if (n2 >= n3)
printf("%d is the largest number.", n2);
else
printf("%d is the largest number.", n3);
}
return 0;
}
Output:
Enter the numbers A, B and C: 2 8 1
8 is the largest number.

More >

Sample Solution C Code:
// C Program to Find Grade of a Student Using If else Ladder #include < stdio.h >
int main() {
float subject_1, subject_2, subject_3, subject_4, subject_5;
float total, average, percentage;
char grade;
printf("Enter the marks of five subjects::\n");
scanf("%f%f%f%f%f", &subject_1, &subject_2, &subject_3, &subject_4, &subject_5);
// It will calculate the Total, Average and Percentage
total = subject_1 + subject_2 + subject_3 + subject_4 + subject_5;
average = total / 5.0;
percentage = (total / 500.0) * 100;
// It will calculate the Grade if (average >= 90)
grade = 'O';
else if (average >= 80 && average < 90)
grade = 'E';
else if (average >= 70 && average < 80)
grade = 'A';
else if (average >= 60 && average < 70)
grade = 'B';
else if (average >= 50 && average < 60)
grade = 'c';
else if (average >= 400 && average < 50)
grade = 'd';
else
grade = 'F';
// It will produce the final output
printf("\nThe Total marks is: \t%.2f / 500.00\n", total);
printf("\nThe Average marks is:\t%.2f\n", average);
printf("\nThe Percentage is: \t%.2f%%\n", percentage);
printf("\nThe Grade is: \t'%c'\n", grade);
return 0;
} Output
Enter the marks of five subjects::
95
85
74
64
53
The Total marks is: 371.00 / 500.00
The Average marks is: 74.20
The Percentage is: 74.20%
The Grade is: 'A'
More >
 

Sample Solution C Code:
#include < stdio.h >
int main() {
int year;
printf("Enter a year: ");
scanf("%d", &year);
// leap year if perfectly divisible by 400
if (year % 400 == 0) {
printf("%d is a leap year.", year);
}
// not a leap year if divisible by 100
// but not divisible by 400
else if (year % 100 == 0) {
printf("%d is not a leap year.", year);
}
// leap year if not divisible by 100
// but divisible by 4
else if (year % 4 == 0) {
printf("%d is a leap year.", year);
}
// all other years are not leap years
else {
printf("%d is not a leap year.", year);
}
return 0;
}
Output 1
Enter a year: 1900
1900 is not a leap year.
Output 2
Enter a year: 2012
2012 is a leap year.
More >
 

Sample Solution C Code:
#include
int main()
{
int n,i,f;
f=i=1;
printf("Enter a Number to Find Factorial: ");
scanf("%d",&n);
while(i<=n)
{
f=f*i;
i++;
}
printf("The Factorial of %d is : %d",n,f);
return 0;
}
OUTPUT:
Enter a Number to Find Factorial: 5
The Factorial of 5 is : 120
More >
 

Sample Solution C Code:
#include< stdio.h >
int main()
{
int i,sum=0,num;//variables
printf("Enter the last element of the series:\n");
scanf("%d",&num);//input::Last element of the series
for(i=1;i<=num;i++)
{
if(i!=