Do you know about aggregate functions? What is row num function? Can it be used all databases?
Answer / nilam
SQL aggregate functions return a single value, calculated from values in a column.
Useful aggregate functions:
AVG() - Returns the average value
COUNT() - Returns the number of rows
FIRST() - Returns the first value
LAST() - Returns the last value
MAX() - Returns the largest value
MIN() - Returns the smallest value
SUM() - Returns the sum
| Is This Answer Correct ? | 6 Yes | 0 No |
what are the database links ?
Where do we use decode and case statements?
Is there a combination of "like" and "in" in sql?
What are virtual columns?
How to create index-by table in oracle?
What are the most common interview questions on ETL Testing for experience?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
List the parts of a database trigger.
How to connect to oracle using service name instead of sid?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
does Oracle has only one table space?
what is port in oracle? how is it related to database application.