Group Function in MySql

//////////////FUNCTIONS///////////////
Group Function(Aggregate Function)
->select MIN(marks) 'MINIMUM MARKS' from student_05;
->select AVG(marks) 'AVERAGE MARKS' from student_05;
->select COUNT(roll_no) "NUMBER OF STUDENT" from student_05;
->select COUNT(roll_no) "NUMBER OF ROWS" from student_05;
->select SUM(marks) 'SUM OF MARKS' from student_05;
->select ABS(-15) 'ABSOLUTE VALUE OF -15' from DUAL;
->select POWER(2,3) 'RAISED' from DUAL;
->select ROUND(15.24532343,3) 'ROUND VALUE' from DUAL;
->select SQRT(36) 'SQUARE ROOT' from DUAL;
->select LOWER('SHARJEEL BILALI') 'LOWER CASE' from DUAL;
->select INITCAP('SHARJEEL BILALI') 'TITLE CASE' from DUAL;
->select UPPER('shaghil bilali') 'UPPER CASE' from DUAL;
->select SUBSTR('SHARJEEL',2,3) 'SUBSTRING' from DUAL;
->select LENGTH('SHARJEEL BILALI') 'LENGTH IS' from DUAL;
->select LTRIM('SHARJEEL','A') 'LEFT TRIM' from DUAL;
->select RTRIM('SHARJEEL','A') 'RIGHT TRIM' from DUAL;
->select LPAD('SHARJEEL',5,'x') 'LEFT PADDING' from DUAL;
->select RPAD('SHARJEEL',5,'x') 'RIGHT PADDING' from DUAL;
->select RPAD(student_name,5,'x') 'RIGHT PADDING' from student_05 where roll_no='0123';

Comments

Post a Comment

Popular posts from this blog

Error : DependencyManagement.dependencies.dependency.(groupId:artifactId:type:classifier)' must be unique: com.adobe.aem:uber-jar:jar:apis -> version 6.3.0 vs 6.4.0

Image
I got above error after adding dependency in Maven POM xml file placed under newly created AEM arch type and running command  mvn -PautoInstallPackage clean install . Error : DependencyManagement.dependencies.dependency.(groupId:artifactId:type:classifier)' must be unique: com.adobe.aem:uber-jar:jar:apis -> version 6.3.0 vs 6.4.0 After google and gone through few article I got command ( mvn -PautoInstallPackage -Padobe-public clean install) . Once I run this command this issue with jar compatibility was resolved. Happy Learning!!!
Read more

Operators in Asterisk with Linux

Operators When you create an Asterisk dialplan, you’re really writing code in a specialized scripting language. This means that the Asterisk dialplan—like any programming language—recognizes symbols called operators that allow you to manipulate variables. Let’s look at the types of operators that are available in Asterisk: Boolean operators These operators evaluate the “truth” of a statement. In computing terms, that essentially refers to whether the statement is something or nothing (non-zero or zero, true or false, on or off, and so on). The Boolean operators are: expr1 | expr2 This operator (called the “or” operator, or “pipe”) returns the evaluation of expr1 if it is true (neither an empty string nor zero). Otherwise, it returns the evaluation of expr2. expr1 & expr2 This operator (called “and”) returns the evaluation of expr1 if both expressions are true (i.e., neither expression evaluates to an empty string or zero). Otherwise, it returns zero. expr1 {=,
Read more

ERROR Exception while handling event Sitecore.Eventing.Remote.PublishEndRemoteEventException: System.AggregateExceptionMessage: One or more exceptions occurred while processing the subscribers to the 'publish:end:remote'

I was getting below error while working with cache management on CM and CD server. Actually my code was working fine on CM server but I was not able to access or clear cache object on CD server because of wrong event selection.  PID[18108] Error       ManagedPoolThread #3 16:24:16 ERROR Exception while handling event Sitecore.Eventing.Remote.PublishEndRemoteEventException: System.AggregateExceptionMessage: One or more exceptions occurred while processing the subscribers to the 'publish:end:remote' event.Source: Sitecore.Kernelat Sitecore.Events.Event.EventSubscribers.RaiseEvent(String eventName, Object[] parameters, EventResult result)at Sitecore.Events.Event.RaiseEvent(String eventName, Object[] parameters)at Sitecore.Eventing.Subscription`1.Invoke(Object instance, EventContext context)at Sitecore.Eventing.EventProvider.RaiseEvent(Object event, Type eventType, EventContext context) Above error comes due to wrong event args access in CD server. There are two event args in
Read more