My Channel Trailer

Comments

Post a Comment

Popular posts from this blog

Standard Input/output Functions in C

  Standard input/output functions   1. character based functions             1.getchar()             2.getche()             3.getch()             4.gets(char*)             5.putchar(char)             6.puts(char*)          2. format based function       scanf() - for accept       printf() - for display       1. format specifier       2. address of variable       In case printf there is no fixed number of argument       printf("hello")       int n1=5,n2=10       Sum of 5 and 10 is 15       printf("Sum of %d and %d is %d",n1,n2,n1+n2)      to disy n values the number of argument is n+1
Read more

SQL Operators

Operator The purpose operators is to perform the manipulations with attributes. These Operators are following 1. Relational Operators - for comparing purpose 2. Arithmetic Operators - for mathematical operations 3. Logical Operators - for compare with multiple conditions or opposition conditions 3. Special Operator - for special purpose comparison Relational Operators >, <, >=, <=, =, !=, <> Examples: Display the details about employee whose name is SMITH select *from emp where ename='SMITH'; Display the details about employees whose salary is greater than 3000 select *from emp where sal > 3000; Display the details about employees except MANAGER select *from emp where job <>'MANAGER' ; or select *from emp where job !='MANAGER' ; Arithmetic Operators +, -, *, / Logical Operators and, or , not Example Display the details about MANAGERS whose salary is greater than 2500 select ename, job, sal from emp where job='MANAGER' and sal...
Read more