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 IS CARDINALITIES OF JOIN?
A lowest level of security by most RDBMS is
what is meant by Dynamic query?
When should you not use firebase?
What is aws documentdb?
What is database bounce?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What are different types of joins used in?
What is the use of default key?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
Clipper / DBF error
What advantages does DBMS have over traditional file systems?
Oracle (3253)
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)