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

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

1 Answer

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 ascending or descending order.The group by clause is used to group rows in a given column and then apply an aggregate function eg max(), min() etc on the entire group.
by

Related questions

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

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

Last 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 ... the total amount of all type of transactions, it will only display the total of credit transactions only.

……………… 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

Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER The above is a) Not an error b) Error - the string in single quotes ‘NORTH’ and ‘SOUTH’ c) Error - the string should be in double quotes d) Error - ORDER BY clause

Description : Select NORTH', CUSTOMER From CUST_DTLS Where REGION = N' Order By CUSTOMER Union Select EAST', CUSTOMER From CUST_DTLS Where REGION = E' Order By CUSTOMER The above is a) Not an error b) Error - ... ' and SOUTH' c) Error - the string should be in double quotes d) Error - ORDER BY clause

Last Answer : d) Error - ORDER BY clause

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

(1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Description : (1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Last Answer : (1)d. Select class, max(marks) from student group by class;(2)b. Both (ii) and (iv)(3)b. select name,max(DOB) from student;

To select slides at discrete order in the Slides Pane you need hold the ………………. on the keyboard while selecting the slides. -Technology

Description : To select slides at discrete order in the Slides Pane you need hold the ………………. on the keyboard while selecting the slides. -Technology

Last Answer : To select slides at discrete order in the Slides Pane you need hold the Ctrl keyon the keyboard while selecting the slides.

Can you use select in FROM clause of SQL select ?

Description : Can you use select in FROM clause of SQL select ?

Last Answer : Yes.

Can you use select in FROM clause of SQL select ?

Description : Can you use select in FROM clause of SQL select ?

Last Answer : Yes.

To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology

Description : To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology

Last Answer : The correct code is :SELECT ID, Salary FROM empsalaryWHERE Salary = 56000 ;

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.

……………..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

How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

Which knowledge base is called as fixed point? a) First-order definite clause are similar to propositional forward chaining b) First-order definite clause are mismatch to propositional forward chaining c) All of the mentioned d) None of the mentioned

Description : Which knowledge base is called as fixed point? a) First-order definite clause are similar to propositional forward chaining b) First-order definite clause are mismatch to propositional forward chaining c) All of the mentioned d) None of the mentioned

Last Answer : a) First-order definite clause are similar to propositional forward chaining

Which closely resembles propositional definite clause? a) Resolution b) Inference c) Conjunction d) First-order definite clauses

Description : Which closely resembles propositional definite clause? a) Resolution b) Inference c) Conjunction d) First-order definite clauses

Last Answer : d) First-order definite clauses

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.

How can a Word document be sent along with an E_mail? -Technology

Description : How can a Word document be sent along with an E_mail? -Technology

Last Answer : By attaching the Word file with an E-mail.

DTD definition is used along with XML to specify -Technology

Description : DTD definition is used along with XML to specify -Technology

Last Answer : (c) DTD definition is used along with XML to specify the structure of XML document.

Explain the concept of cell referencing along with its various types. -Technology

Description : Explain the concept of cell referencing along with its various types. -Technology

Last Answer : Excel supports three types of cell referencing, which are as follows:1. Relative Every relative cell reference in formula automatically changes when the formula is copied down a column or across a ... from one cell to another, the absolute reference stays the same but the relative reference changes.

What is the purpose of <IMG> tag ? Mention it’s any two attributes along with their purpose. -Technology

Description : What is the purpose of tag ? Mention it’s any two attributes along with their purpose. -Technology

Last Answer : tag is used to insert images in any webpage.Its two main attributes are as follows:SRC : It specifies the URL of the image.ALT : It specifies an alternate text for an image.

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)

(i) To display names of stores along with Sales Amount of those stores that have ‘fashion’ anywhere -Technology

Description : (i) To display names of stores along with Sales Amount of those stores that have ‘fashion’ anywhere -Technology

Last Answer : mysql> Select Name,SalesAmt from Store order by noOfEmp;mysql> Select city, sum(SalesAmt) from store group by City;mysql> Select count(*),City from store group by City having count(*)>2; ... ;Min(DateOpen)2015-02-06mysql> Select Count(StoreId), NoOfEmp from Store group byNoOfemp having max(SalesAmt)

Write a query to display customer’s name along with their transaction details. -Technology

Description : Write a query to display customer’s name along with their transaction details. -Technology

Last Answer : Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;

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.

Which attribute lets you control the display of select border sides of a table? -Technology

Description : Which attribute lets you control the display of select border sides of a table? -Technology

Last Answer : frame attribute displays the selected border sides of the table.

In the Print dialog box, you can select the pages for printing. (a) Even pages (b) Odd pages (c) All pages in range (d) All of these -Technology

Description : In the Print dialog box, you can select the pages for printing. (a) Even pages (b) Odd pages (c) All pages in range (d) All of these -Technology

Last Answer : (d) You can select the even, odd and all pages in range for printing.

While performing Mail Merge, in how many ways can you select recipients? Explain any one of them. -Technology

Description : While performing Mail Merge, in how many ways can you select recipients? Explain any one of them. -Technology

Last Answer : When you open or create a data source by using the Mail Merge wizard, you are telling Word to use a specific set of variable information for your merge. Use one of the following methods to attach ... this point, you are also saving the data source and attaching the data source to the main document.

What are the steps to insert a readymade shape in a document? (a) I. Select the Insert tab. -Technology

Description : What are the steps to insert a readymade shape in a document? (a) I. Select the Insert tab. -Technology

Last Answer : (a) I. Select the Insert tab.II. In the Illustrations group, click on Shapes and select desired shape.III. Click and hold the mouse, where you want to draw the shape and drag the mouse pointer keeping the mouse pressed.IV. Release the mouse button.

Why do librarians select open source library automation software? -Technology

Description : Why do librarians select open source library automation software? -Technology

Last Answer : Librarians select open source library automation software because of following advantages:i. It is normally available free of cost;ii. One can download it with the help of its source code for any type of library usageiii. One is allowed to modify its source code for satisfying his/ her requirements.

i. select city from training where topic = 'Cyber Security'; -Technology

Description : i. select city from training where topic = 'Cyber Security'; -Technology

Last Answer : i. New DelhiFaridabadGurugramii. 2iii. 11000iv. Ms. Neena

Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Description : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Last Answer : The correct answer is : (a) 50

What is the difference between a clause and phrase?

Description : What is the difference between a clause and phrase?

Last Answer : Phrases and clauses are both groups of two or more words that convey ideas. However, there is an easy way to tell if you're using a phrase or a clause. The main difference is that clauses have both a subject and a predicate; phrases do not. Phrases are part of clauses.

Once the project is approved and moves into the planninb. The total risk on the project typically reduces as activities are performed without loss. c. Risks must be weighed against the potential benefit of the project’s success in order to decide if the project should be chosen. d. Risks are identified with each major group of activities. e. A risk response plan can be used to identify increasing levels of detailed risk analysisg stage, what happens in the next phase of the project life cycle? Select one: a. Agreements for risk sharing need to be concluded.

Description : Once the project is approved and moves into the planning stage, what happens  in the next phase of the project life cycle? Select one: a. Agreements for risk sharing need to be concluded. ... activities. e. A risk response plan can be used to identify increasing levels of detailed risk analysis

Last Answer : d. Risks are identified with each major group of activities.

Once the project is approved and moves into the planning stage, what happens in the next phase of the project life cycle?Select one: a. Agreements for risk sharing need to be concluded. b. The total risk on the project typically reduces as activities are performed without loss. c. Risks must be weighed against the potential benefit of the project’s success in order to decide if the project should be chosen. d. Risks are identified with each major group of activities. e. A risk response plan can be used to identify increasing levels of detailed risk analysis

Description : Once the project is approved and moves into the planning stage, what  happens in the next phase of the project life cycle? Select one: a. Agreements for risk sharing need to be concluded. ... activities. e. A risk response plan can be used to identify increasing levels of detailed risk analysis

Last Answer : d. Risks are identified with each major group of activities.

Choose the correct statement. (a) Electronegativity increases down a group (b) Electronegativity decreases down a group (c) Electronegativity decreases from left to right along a period (d) Electronegativity changes along a group, but remains constant along a period

Description : Choose the correct statement. (a) Electronegativity increases down a group (b) Electronegativity decreases down a group (c) Electronegativity decreases from left to right along a period (d) Electronegativity changes along a group, but remains constant along a period

Last Answer : Ans:(b)

Complete the following statement. As the project progresses into the execution phase: Select one: a. risks need to be checked off on activities that have been performed. b. the total risk on the project typically increases. c. risks are identified with each major group of activities. d. a risk response plan can be used to identify increasing levels of detailed risk analysis. e. the risk breakdown structure needs to be examined to be sure all the risk events have been avoided.

Description : Complete the following statement. As the project progresses into the  execution phase: Select one: a. risks need to be checked off on activities that have been performed. b. the total risk on ... risk breakdown structure needs to be examined to be sure all the risk events have  been avoided.

Last Answer : a. risks need to be checked off on activities that have been performed.

Select the correct statement. (A) More the value of group index, less thickness of pavement will be required (B) More the value of CBR, greater thickness of pavement will be required (C) Minimum and maximum values of group index can be 0 and 20 respectively (D) All of the above

Description : Select the correct statement. (A) More the value of group index, less thickness of pavement will be required (B) More the value of CBR, greater thickness of pavement will be required (C) Minimum and maximum values of group index can be 0 and 20 respectively (D) All of the above

Last Answer : Answer: Option C

A ……… is a group of related fields. -Technology

Description : A ……… is a group of related fields. -Technology

Last Answer : A databaseis a group of related fields.

computer network. A computer network is a group of (i) ………. that are (ii) ……… to each other for the purpose o -Technology

Description : computer network. A computer network is a group of (i) ………. that are (ii) ……… to each other for the purpose o -Technology

Last Answer : (i) computers(ii) connected(iii) communication(iv) network(v) share

A group of computers connected together with the help of cables within an office building is called (a) PAN (b) WAN -Technology

Description : A group of computers connected together with the help of cables within an office building is called (a) PAN (b) WAN -Technology

Last Answer : (d) Using LAN, we can connect computers within a building only.

The Themes group is presented on ………….. tab. (a) Home (b) Page Layout (c) References (d) Picture Tools Format -Technology

Description : The Themes group is presented on ………….. tab. (a) Home (b) Page Layout (c) References (d) Picture Tools Format -Technology

Last Answer : (b) The Themes group is presented on Page Layout tab.

Under the Insert tab, which group contains the features like Shapes, ClipArt? -Technology

Description : Under the Insert tab, which group contains the features like Shapes, ClipArt? -Technology

Last Answer : Under Insert tab, Illustrations group contains the features like Shapes, ClipArt etc.

Under which tab, Comments group is present, ……………… (a) Insert (b) Review (c) View (d) Mailings -Technology

Description : Under which tab, Comments group is present, ……………… (a) Insert (b) Review (c) View (d) Mailings -Technology

Last Answer : (b) Review tab contains the Comments groug.

The Insert button is found on Cells group under Home tab. -Technology

Description : The Insert button is found on Cells group under Home tab. -Technology

Last Answer : True Insert button is available on Cells group under Home tab and is used to insert cells, rows, and columns.

What is quota sampling? Do you agree that the quota sampling is more reflective of the entire group? -Technology

Description : What is quota sampling? Do you agree that the quota sampling is more reflective of the entire group? -Technology

Last Answer : Quota sampling is a method for selecting survey participants. In quota sampling, a population is first segmented into mutually exclusive sub-groups. Then judgment is used to select the subjects or units from each segment based on a specified proportion.' {Rest of the answer is subjective}

Complete the following statement. The method of incorporating change into project planning and execution processes is called the: Select one: a. project logic diagram. b. change management process. c. milestone schedule d. critical path e. rough order of magnitude

Description : Complete the following statement. The method of incorporating change into  project planning and execution processes is called the: Select one: a. project logic diagram. b. change management process. c. milestone schedule d. critical path e. rough order of magnitude

Last Answer : b. change management process.

In order to use the printer, an operating system will need a special type of software. This software is known as what? -Technology

Description : In order to use the printer, an operating system will need a special type of software. This software is known as what? -Technology

Last Answer : In order to use the printer, an operating system will need a device driver software.

Ramya wants to connect all the computers of her office wirelessly in order to avoid clumsy cables. -Technology

Description : Ramya wants to connect all the computers of her office wirelessly in order to avoid clumsy cables. -Technology

Last Answer : Wi-Fi technology would be best suitable for her office to avoid cabling.

“Information helps us in taking decisions”. What should be the characteristics of processed data in order to take meaningful decision? -Technology

Description : “Information helps us in taking decisions”. What should be the characteristics of processed data in order to take meaningful decision? -Technology

Last Answer : For the decision to be meaningful, the processed data (or information) must have the following characteristics:1. Time Information should be available when required.2. Accuracy Information should be accurate.3. Completeness Information should be complete in every aspect.