Discuss the significance of having clause with group by statement with suitable example. -Technology

Discuss the significance of having clause with group by statement with suitable example. -Technology
by

1 Answer

Answer :

Sometimes we do not want to see the whole output produced by a statement with Group By clause. We want to see the output only for those groups which satisfy some condition. It means we want to put some condition on individual groups (and not on individual records). A condition on groups is applied by Having clause.For example consider the following query:select Acc_No, sum(Amount) from Customer c, Transaction t where c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type='Credit';This query will create account number wise groups and instead of displaying the total amount of all type of transactions, it will only display the total of credit transactions only.
by

Related questions

What is the difference between the order by and group by clause when used along with the select statement. -Technology

Description : What is the difference between the order by and group by clause when used along with the select statement. -Technology

Last Answer : The order by clause is used to show the contents of a table/relation in a sorted manner with respect to the column mentioned after the order by clause. The contents of the column can be arranged in ... a given column and then apply an aggregate function eg max(), min() etc on the entire group.

Discuss the five fundamental categories, PMEST, with the help of suitable example. -Technology

Description : Discuss the five fundamental categories, PMEST, with the help of suitable example. -Technology

Last Answer : P: Personality-the facet indicates the core point of the subject at handM: Matter-reflects substance or material of the subjectE: covers problem, action including methods, functioning, and other ... their subdivisions, continent, etc.Time: represents periods, like, years, decades, centuries, etc.

Discuss the significance of Bluetooth technology. -Technology

Description : Discuss the significance of Bluetooth technology. -Technology

Last Answer : Bluetooth is a wireless technology standard for exchanging data over short distances using short-wavelength radio waves.It is used in building personal area networks (PANs).Now a days many gadgets and peripheral devices are Bluetooth enabled like Speakers, mouse, headphone, printer etc.

What is the significance of having storage clause ?

Description : What is the significance of having storage clause ?

Last Answer : We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free for managing row updations etc.,

.“We all have more than one identity and can belong to more than one social group.” Discuss the statement with suitable examples. -SST 10th

Description : .“We all have more than one identity and can belong to more than one social group.” Discuss the statement with suitable examples. -SST 10th

Last Answer : (i) Carlos and Smith were similar in one way, i.e., they both were African-Americans and thus different from Norman who was white. But they were also all similar in other ways - they ... . identity and can belong to more than one social group. We have different identities in different contexts.

What is the significance of icons? Give the example of any three types of icons. -Technology

Description : What is the significance of icons? Give the example of any three types of icons. -Technology

Last Answer : Icons refer to graphic symbols that represent window elements. The three types of icons are as follows- the application icon, the shortcut icon and the document icon.

……………..specifies a search condition for a group or an aggregate. A) GROUP BY Clause B) HAVING Clause C) FROM Clause D) WHERE Clause

Description : ……………..specifies a search condition for a group or an aggregate. A) GROUP BY Clause B) HAVING Clause C) FROM Clause D) WHERE Clause

Last Answer : B) HAVING Clause

……………… clause is an additional filter that is applied to the result. A) Select B) Group-by C) Having D) Order by

Description : ……………… clause is an additional filter that is applied to the result. A) Select B) Group-by C) Having D) Order by

Last Answer : C) Having

What is the use of <tr> tag in an HTML table? Give a suitable example. -Technology

Description : What is the use of tag in an HTML table? Give a suitable example. -Technology

Last Answer : The tag creates a table row in an HTML table. A table must have atleast one row and also, it can have as many table rows as you want. A table row is divided into table cells. A table must have atleast one table cell per table row.e.g.CheadXtitle> TR Tag

Differentiate between <OL> and <UL> tag with suitable example. -Technology

Description : Differentiate between and tag with suitable example. -Technology

Last Answer : stands for Ordered List which can be either numerical or alphabetical while stands for Unordered List which can be either ... AND OUTPUTCODEHobbiesprogrammingDramaticsCODEHobbiesGamesProgrammingDramaticsOUTPUTHobbies1. Games2. Programming3. DramaticsOUTPUTHobbies1. Games2. Programming3. Dramatics

Differentiate between Web sites and Web pages with suitable example of each. -Technology

Description : Differentiate between Web sites and Web pages with suitable example of each. -Technology

Last Answer : Thedifference between awebsiteand aweb pageis that awebsiteis a collection ofwebpages with information on a subject, and aweb pageis a smaller part of a largerwebsiteusually containing more specific information. If awebsitewere a book, then awebpagewould be a chapter in that book.

Differentiate between Websites and Webpages with suitable example of each. -Technology

Description : Differentiate between Websites and Webpages with suitable example of each. -Technology

Last Answer : Using the same book analogy, while awebpageis apagefrom a book, awebsiteis the book itself. It is a collection of thepagesthat share a common thread. Similarly, all thewebpagesof yourwebsitecome together to form yourwebsite.

Which are more suitable normal form to be used with definite clause? a) Positive literal b) Negative literal c) Generalized modus ponens d) Neutral literal

Description : Which are more suitable normal form to be used with definite clause? a) Positive literal b) Negative literal c) Generalized modus ponens d) Neutral literal

Last Answer : c) Generalized modus ponens

What is the significance of a primary key? -Technology

Description : What is the significance of a primary key? -Technology

Last Answer : A primary key cannot allow null values and must have a unique index.

Write the significance of a foreign key. -Technology

Description : Write the significance of a foreign key. -Technology

Last Answer : A foreign key is used to Establish the relationship between any two tables of RDBMS.

Write down the significance of electronic spreadsheets. -Technology

Description : Write down the significance of electronic spreadsheets. -Technology

Last Answer : Using electronic spreadsheets, a large volume of data can be stored in worksheets. Worksheets can be managed, edited, viewed, retrieved and printed easily in the desired format. Electronic spreadsheets support charts, which represent data pictorially.

What is the significance of System Software? -Technology

Description : What is the significance of System Software? -Technology

Last Answer : System software includes the programs that enable the computer’s hardware to work with and run the application software.OrSystem software is the interface between user, other programs and the computer’s hardware.

Discuss the economic significance of the longest railway line of the world. -Geography

Description : Discuss the economic significance of the longest railway line of the world. -Geography

Last Answer : Trans-Siberian Railways is the longest trans continental railways with 9332 km. (i) It has helped in opening up its Asian region to West European markets. (ii) It runs across the Ural ... v) Coal, oil, wood, agro products from the forest are transported by this railways along with foodgrains.

Sakshi is preparing a lecture on output device like monitor. Discuss. (i) Give some advantages of the output device ‘monitor’. -Technology

Description : Sakshi is preparing a lecture on output device like monitor. Discuss. (i) Give some advantages of the output device ‘monitor’. -Technology

Last Answer : (i) (a) Relatively cheap and reliable.(b) Can display text and graphics in a wide range of colors.(ii) (a) No permanent copy to keep the results as it will disappear when the computer is switched OFF.(b) Unsuitable for users with visual problems.

Discuss the structure of an E_mail message. -Technology

Description : Discuss the structure of an E_mail message. -Technology

Last Answer : In an E-mail message, you will see the following fields which are as follows: To Mail-id of a recipient. Cc (Carbon copy) It allows you to send the same mail message to multiple recipients at ... Send button Once you complete the E-mail message, click at Send button to send the E-mail message.

Discuss the components of a database. -Technology

Description : Discuss the components of a database. -Technology

Last Answer : A database consists of several components. Each component plays an important role in the database system environment.The major components of the database are as follows:DataIt is raw numbers, ... perform different operations on the database by inserting, deleting etc., through menus or forms.

Discuss the features of Title bar. -Technology

Description : Discuss the features of Title bar. -Technology

Last Answer : Title bar displays the name of the window or software program. This bar can maximize, minimize, restore or close a window. It is also used to move a window using any pointing device.

Discuss the advantages and disadvantages of advertising in different forms of media. -Technology

Description : Discuss the advantages and disadvantages of advertising in different forms of media. -Technology

Last Answer : Student should be able to discuss following five points During the process of Adaptation:i. A new narrative is formed.ii. The new narrative in formed another medium.iii. Script-writer and Director ... context of the original may change.v. The new narrative is an interpretation of the original.

What is the need of a database? Discuss briefly. -Technology

Description : What is the need of a database? Discuss briefly. -Technology

Last Answer : Database is usually a large collection of data which is organized in a very effective and efficient manner. It allows the user for rapid search and retrieval of required information.

Discuss the purpose of HTTP briefly. -Technology

Description : Discuss the purpose of HTTP briefly. -Technology

Last Answer : Full form of HTTP is Hypertext Transfer Protocol. It is the foundation of data communication for the World Wide Web.

Select Acc_No, sum(Amount) from Customer c, Transaction t where c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type='Credit'; -Technology

Description : Select Acc_No, sum(Amount) from Customer c, Transaction t where c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type='Credit'; -Technology

Last Answer : 2301003 650002201002 20000

Choose the group of words that is not an independent clause?

Description : Choose the group of words that is not an independent clause?

Last Answer : Experiencing unemployment during the depression.

If you find a child in your class who always isolates from the rest of the class, you would ... Options: A) ask the child to be normal by taking example of his classmates B) try to understand the underlying clause C) leave the child alone so that the child comes out of his own D) inform the management that his presence may affect other students of the class.

Description : If you find a child in your class who always isolates from the rest of the class, you would ... Options: A) ask the child to be normal by taking example of his classmates B) try to understand ... comes out of his own D) inform the management that his presence may affect other students of the class.

Last Answer : B) try to understand the underlying clause 

Name the term defined by given below statement: “A group of computers connected to each other by a link.” -Technology

Description : Name the term defined by given below statement: “A group of computers connected to each other by a link.” -Technology

Last Answer : Computer network is defined as a group of computers connected to each other by a link.

When do you use WHERE clause and when do you use HAVING clause?

Description : When do you use WHERE clause and when do you use HAVING clause?

Last Answer : HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

State what is the significance of conducting phasing out test on a 3-phase transformer? Explain its procedure with a suitable connection diagram.

Description : State what is the significance of conducting phasing out test on a 3-phase transformer? Explain its procedure with a suitable connection diagram.

Last Answer : -Short primary & secondary winding of other phases expect the one under test. -Connect voltmeter to secondary winding. -A small DC current is circulated through the primary winding through ... . -The test repeated for finding out remaining concerned secondary windings in the same manner.

Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Description : Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Last Answer : (b) From the given options, the data field can not be set as a primary key because it can’t be fixed for an object.

Twisted pair cable is suitable for broadband application. -Technology

Description : Twisted pair cable is suitable for broadband application. -Technology

Last Answer : FalseTwisted pair cable has low bandwidth capabilities and broadband application requires high bandwidth.

Briefly explain the two broad categories of a newspaper format giving suitable examples. -Technology

Description : Briefly explain the two broad categories of a newspaper format giving suitable examples. -Technology

Last Answer : The analysis of newspaper content suggests two broad categories of newspaper formatBroadsheet Press (quality or serious press)…. Explanation with examplesTabloid Press (Popular or sensational press)… Explanation with examples

Explain the purpose of pow() method with the help of suitable java code. Also mention that pow() method belongs to which class? -Technology

Description : Explain the purpose of pow() method with the help of suitable java code. Also mention that pow() method belongs to which class? -Technology

Last Answer : pow() method, a mathematical method, helps in calculating the power of any number.For example:int num=2,power=4;int ans=Math.pow(num,power);t1.setText(''+ans);The above code will calculate the value of 24 and will give answer 16.pow() method belongs to math class.

Suggest the suitable data type for Issue_Date column. -Technology

Description : Suggest the suitable data type for Issue_Date column. -Technology

Last Answer : (i)Date(ii) alter table library modify name varchar(50);(iii) Bid column will always have a unique value which will help uniquely identify each record of Library table.(iv) Select name from library order by status desc;

Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Description : Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Last Answer : Column NameData TypeRollNoIntegerNameVarchar(20)

Which software model is best suitable for client server application? -Technology

Description : Which software model is best suitable for client server application? -Technology

Last Answer : Concurrent Process model is best suitable for client server application.

What statement accurately describes the supremacy clause of the constitution?

Description : What statement accurately describes the supremacy clause of the constitution?

Last Answer : It says that Federal Laws are superior to state laws -Apex

True or false if you took a true “if-then” statement and inserted a not in each clause, the new statement would also be true?

Description : True or false if you took a true “if-then” statement and inserted a not in each clause, the new statement would also be true?

Last Answer : FALSE

How does a try statement determine which catch clause should be used to handle an exception?

Description : How does a try statement determine which catch clause should be used to handle an exception?

Last Answer : Ans. When an exception is thrown within the body of a try statement, the catch clauses of the try statement are examined in the order in which they appear. The first catch clause that is capable of handling the exception is executed. The remaining catch clauses are ignored.

Discuss with your teacher what does ‘a suitable gene’ means, in the context of DNA vaccines. -Science

Description : Discuss with your teacher what does ‘a suitable gene’ means, in the context of DNA vaccines. -Science

Last Answer : A DNA vaccine consists of a suitable gene encoding an antigenic protein, inserted into a plasmid, and then incorporated into the cells in a target animal. The plasmid vaccine carrying the DNA (gene ... on their surface, the immune system is alerted, which then triggers a range of immune responses.

Explain the process of socialization with suitable examples and discuss any one agency of socialization you are member of.

Description : Explain the process of socialization with suitable examples and discuss any one agency of socialization you are member of.

Last Answer : Explain the process of socialization with suitable examples and discuss any one agency of socialization you are member of.

Briefly discuss the classification of plants giving suitable examples:

Description : Briefly discuss the classification of plants giving suitable examples:

Last Answer : There are nearly half a million species of plants on the earth. With the exception of few , all of them need three basic ingredients to survive : air , light and water . Plants are found ... angiosperms include most other trees , the flowering plants, the grasses , crop plants , vegetable and weeds.

Discuss functions of flux used to welding. Identify properties of material suitable for flux and state two materials used as flux.

Description : Discuss functions of flux used to welding. Identify properties of material suitable for flux and state two materials used as flux.

Last Answer : Functions of flux 1. A flux is a material used for removal of oxides and other undesirable substances. 2. Flux is a material used to prevent dissolve or facilitate removal of oxide. 3. ... in liquid 5. For welding alloy steel:- Mixture of boric acid , Dehydrated borax and calcium fluorides

Discuss hybrid topology with suitable diagram.

Description : Discuss hybrid topology with suitable diagram. 

Last Answer : Discuss hybrid topology with suitable dig. Hybrid topology is one that uses two or more basic topologies together Fig.1 depicts this. In this case, the bus, star & ring topologies are used to ... many networks are quite complex but they can be reduced to some form of hybrid topology.

How the atomic size vary in a group and across a period? Explain with suitable example.

Description : How the atomic size vary in a group and across a period? Explain with suitable example.

Last Answer : How the atomic size vary in a group and across a period? Explain with suitable example.

Better classroom management means (a) per group work and better interaction among pupils (b) prior preparation of teacher in the making of suitable aids (c) Punctuality of the teachers in coming in the class and finishing the course in time (d) Getting the attention and cooperation of all the students before starting the class/ task (e) Moving around the room to identify pupils having or creating problems (f) Avoid teaching when pupils are not in proper mood (g) All of these

Description : Better classroom management means (a) per group work and better interaction among pupils (b) prior preparation of teacher in the making of suitable aids (c) Punctuality of the teachers in coming in the ... creating problems (f) Avoid teaching when pupils are not in proper mood (g) All of these

Last Answer : (g) All of these

Can we discuss the Adria Richards thing better than the rest of the internet?

Description : Can we discuss the Adria Richards thing better than the rest of the internet?

Last Answer : answer:I had very little exposure to the story and the associated vitriol, but it does seem to be a bit of a tempest in a teapot. So here's my first question: if Adria ... that environment except through public shaming. It just seems unfortunate that it's become such a contentious occurance.

I want to file this patent, but I don't know what makes it original. Can I meet with a professional to discuss it?

Description : I want to file this patent, but I don't know what makes it original. Can I meet with a professional to discuss it?

Last Answer : Just because it’s never been done doesn’t mean that there isn’t a patent filed for it. You need to speak with a patent attorney.