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 |
Is database a hardware or software?
What is the relationship that exists inside in E-R diagram?
What is database collection?
how can you perform lookup range in lookup stage expalin in detail?
Define the following terms i. Inverted List ii. Candidate Key iii. B-Tree iv. Foreign Key
what is the full procedure for using store procedure in informatica7.1?
Explain entity type?
Can we have a function Overloading with same number of arguments but with different return types of function
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
What is difference between clustered, non-clustered and unique index?
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?