What is the differnce between Order by and Group by
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between a stored procedure and a query?
How concurrency problems effect the database?
What is global database name?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
What are the types of indexes that are present inside a database?
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
What are the advantages of using database?
Display the employees whose salary is less than average salary.
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
What is Data Modelling?
Explain entity set?
What are the disadvantages of views in a database?
List some advantages of dbms.
aht is the difference b/w network & hierarchial & relational dbms????
What is ole db in ssis?