What is the differnce between Order by and Group by
Answer / guest
Order by is to sort the output records based on some
columns and group by is to group the records and to apply
aggregate functions on the particular columns
Is This Answer Correct ? | 6 Yes | 1 No |
1.what are components of querystdio and report studio and cognoss connection? 2. how to use prompts in query studio? 3.what is lock and un lock objects? 4.how to test the re[ports in query studio? 5.how to use brust option and when? 6.what is the performance testing? 7.condition explorer whaen your using? 8.in impromptu how do you create cascading prompt? 9.diff between section and group? 10.types filters where you are using group filters and tabular filter? 11.tabular model, tabular references ,tabular set , tabular sql? 12.what is the use of multi[le packages? 13what types of problems arise when create a join? 14.how to provide package sequirety? 15.report server components? 16.how many kinds of quality subjects? 17.how do you specify the joins? 18.how would you maintain the relations in frame work manager? 19.what is usage of segments and how to provide it? 20.governer settings in frame work maneger? 21.how to create filter in frame work manager? 22diffrence between represention layer and physical layer? 23.how to create prompts in frame work manager? 24.what errors occured when verify the model? 25.how to publish package in net work or local system?
Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?
Is storing images in a database a good idea?
aht is the difference b/w network & hierarchial & relational dbms????
How is image stored in database?
Differentiate between unique key and foreign key?
Explain buffer manager?
What is the importance of database partitioning?
what is Normalization means..?
8 Answers AZTEC, Bank Of America, Infosys, TCS,
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
Which is the best sorting method if i have to sort the students of Harvard University according to their first name?
What is the advantage of varchar2 over char?