The SQL WHERE Clause 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 clau…
SQL ALTER TABLE Statement SQL ALTER TABLE Statement The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. The ALTER TABLE statement is also used to add and drop various constraints on an existing table. ALTE…
R Programming: To Check Number Prime or Not R Programming Code : num = as.integer(readline(prompt="Enter a number: ")) f = 0 if(num > 1) { f = 1 for(i in 2:(num-1)) { if ((num %% i) == 0) { f = 0 brea…
R Programming: To create 3 vectors A,B,C with 3 integers combine the three vectors to be column 3*3 matrix where with column represent vector print the content of matrix R Programming Code : A<-c(12,3,24) B<-c(21,43,3) C<-c(4,6,5) D<-c…
R Programming: Create a Data Frames which contain details of 5 employees and display details of employees R Programming Code : Emp=data.frame(Name=c("Tushar","Gaurav","Gauri","Sagar","Kalyani"), Gend…
R Programming: To check number positive or negative R Programming Code : num=as.integer(readline(prompt ("Enter a number "))) if(num>0) { print(paste(num,"is positive")) } else { print(paste(num,"is negative")) }…
