@Dheerendra

-- order-by create table customer(customerID int,customerName varchar(255),country varchar(255)); insert into customer(customerID, customerName,country)values(1,"Alfred","Germany"),(2,"John","Argentina"),(3,"William","America"); select * from custom

/* Leap Year*/ #include<stdio.h> int main(){ int n; printf("Enter a number: "); scanf("%d",&n); if(n%400==0){ printf("\n%d is a leap year",n); }else if(n%100==0){ printf("\n%d is not a leap year",n);

/* Prime number*/ #include<stdio.h> int main(){ int n,dv,i; printf("Enter a number"); scanf("%d",&n); for(i=1;i<=n;i++){ if(n%i==0){ dv=dv+1; }

/* palindrome number*/ #include <stdio.h> int main() { int n,reversed=0,original, remainde ; printf("Enter an integer : "); scanf("%d",&n); original=n; while(n!=0){

/* like operator */ -- The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. -- There are two wildcards often used in conjunction with the LIKE operator: -- The percent sign (%) represents zero, one, or multiple

-- between operator : -- The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates. -- The BETWEEN operator is inclusive: begin and end values are included. -- BETWEEN Syntax---- -- SELECT column_name(s) F

-- writing two values of a row together just as we write in starting -- it is similar to concatenation in string create table employee(EmpID int, EmpFirstName varchar(255),EmpLastName varchar(255),Address varchar(255),salary int); insert into emplo

/*alias table*/ -- SQL aliases are used to give a table, or a column in a table, a temporary name.. -- An alias is created with the AS keyword. create table employee(EmpID int, EmpFirstName varchar(255),EmpLastName varchar(255),Address varchar(255),

/* performing addition operation on Marks column in student table */ create Table student1(Name varchar(255),RollNo varchar(255),Marks int); insert into student1(Name, RollNo ,Marks)values("Ram",1,42); insert into student1(Name, RollNo ,Marks)value

#include <stdio.h> /*pattern- # # # # # # # # # # # # # # # */ int main() {

/* Foreign Key*/ create Table student1(Name varchar(255),RollNo varchar(255),Marks int); insert into student1(Name, RollNo ,Marks)values("Ram",1,42); insert into student1(Name, RollNo ,Marks)values("John",2,43); insert into student1(Name, RollNo ,M

create table Supplier(Supplier_ID int, Supplier_Name varchar(255), Contact_Name varchar(255)); insert into Supplier(Supplier_ID, Supplier_Name, Contact_Name)values(13,"rexon","Rex"); insert into Supplier(Supplier_ID, Supplier_Name, Contact_Name)valu

-- wrong code -- foreign key -- The FOREIGN KEY constraint is used to prevent actions that would destroy links between tables. -- A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in another table. -- Th

-- primary key -- The PRIMARY KEY constraint uniquely identifies each record in a table. -- Primary keys must contain UNIQUE values, and cannot contain NULL values. -- A table can have only ONE primary key create table Person(PersonID int Primary ke

-- /*check command */ -- The CHECK constraint is used to limit the value range that can be placed in a column. -- If you define a CHECK constraint on a column it will allow only certain values for this column. -- If you define a CHECK constraint on

-- create table create table Person2(name varchar(255),age int default 18,address varchar(255) default "Delhi"); insert into Person2(name)VALUES("KEN"); insert into Person2(name)VALUES("TEMI"); insert into Person2(name)VALUES("ROBERTO"); SELECT * FR

-- creating a table create table Person1(ID int Not Null Unique, LastName varchar(255) NOT NULL, FirstName varchar(255),Age int); insert into Person1(ID, LastName, FirstName, Age)values(101,"Singh","Dheerendra",20); insert into Person1(ID, LastName,

//Print sum of multiples of 7 from 1 to given input using do while #include<stdio.h> int main() { int i=1,j,sum=0; printf("Enter the number : \n"); scanf("%d",&j); do{ if(i%7==0)

//Print multiples of 5 from 1 to 100 using do while #include<stdio.h> int main() { int i=1; do { if(i%5==0) printf("%d ",i); i++;

//Print 2's table using do while #include<stdio.h> int main() { int i=2,j=1; do { printf("%d ",i*j); j++; }while(j<=10);