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 |
What happens when shared and exclusive locks are applied on data item?
Write a query to get maximum and second maximum in oracle?
How much does it cost to build a database?
if i want to display the name of students such that to which city they belong must have count greaer than two
What is a sequence? Explain it with one example?
What does new grouping sets enables you to do?
Is database a hardware or software?
What is OQL?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
What is ole db used for?
What are different types of clusters present?
Explain file manager?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)