Satya Prakash 
What is MySQL limit clause? The LIMIT clause is used in the SELECT statement to constrain the number of rows in a result set. The LIMIT clause accepts one or two arguments. The values of both arguments must be zero or positive integers. It limits the Data Selections from a MySQL Database. The LIMIT clause … Read more
Description: MySQL LENGTH() returns the length of a given string. Syntax: LENGTH (str) Argument: Name Description str A string whose length is to be returned. Example of MySQL LENGTH() function mysql> SELECT LENGTH(NULL); Result: NULL mysql> SELECT LENGTH(”); Result: 0 mysql> SELECT LENGTH(‘ ‘); Result: 1 mysql> SELECT … Read more
MySQL CONCAT function is used to concatenate two strings to form a single string. Description: MySQL CONCAT() function is used to add two or more strings. There may be one or more arguments. Returns the string that results from concatenating the arguments. Returns a non binary string, if all arguments are non binary strings. Returns … Read more
Since we have now added the logical operators to the list of operators we know, it is time to review these operators and their priorities. The higher the position of an operator is in the table, higher is its priority. The following figure summarizes the working of all the three logical operators.
MySQL SUBSTRING() returns a specified number of characters from a particular position of a given string. Syntax: SUBSTRING(str, pos, len) or SUBSTRING(str FROM pos FOR len) Arguments Name Description str A string. pos Starting position. len … Read more
In this article we will learn about the NOT operator, written as !. This operator reverses the result of the expression it operates on. For example, if the expression evaluates to a non-zero value, then applying ! operator to it results into a 0. Vice versa, if the expression evaluates to zero then on applying … Read more
As far as preparation for IES is concerned, it differs from person to person and how much they are confident with the basics of every topic. I recommend that you go through the past year papers and analyze them thoroughly. Find out the kind of questions that need the most work. You definitely need to … Read more
Problem Statement: Write a program to calculate the salary as per the following table: Solution: /* C program to calculate salary */ main( ) { char g ; int yos, qual, sal ; printf ( “Enter Gender, Years of Service and Qualifications ( 0 = G, 1 = PG ):” ) ; scanf ( “%c%d%d”, &g, … Read more
Let’s have an example to understand else if clause : /* else if ladder demo */ main( ) { int m1, m2, m3, m4, m5, per ; per = ( m1+ m2 + m3 + m4+ m5 ) / per ; if ( per >= 60 ) printf ( “First division” ) ; else if … Read more
C allows usage of three logical operators, namely, &&, || and !. These are to be read as ‘AND’ ‘OR’ and ‘NOT’ respectively. There are several things to note about these logical operators. Most obviously, two of them are composed of double symbols: || and &&. Don’t use the single symbol | and &. These … Read more