Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Common SQL Functions Used for Data Aggregation?
- 1 Answers
- 2460 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
SUM(): Determines a numeric column's total sum.
AVG(): Determines a numeric column's average value.
COUNT(): Determines how many rows satisfy a certain criterion.
MIN(): Determines a column's lowest value.
MAX(): Determines a column's maximum value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between nested loop, hash loop and merge join.
What is the purpose of a field in a database?
What are the main features of a database?
Explain the different types of database keys?
What is a database in business?
Can we linked SharePoint to a SQL databasebe?
What is unique key example?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
How to load a file into database column?
What is ddl in dbms?
What is index hunting and how does it help in improving query performance?
Is declare cursor executable?
What are the different technologies used to access Database from Visual Basic?
What is sorting in dbms?
What are the properties of a primary key in DBMS?
