Filter interviews by
I applied via Naukri.com and was interviewed before Apr 2022. There were 2 interview rounds.
To show aggregation on whole data row by row in SQL, you can use the OVER() function with appropriate window specification.
Use the OVER() function to perform aggregation on the entire data set
Specify the window specification to define the scope of aggregation
Add the aggregated result as a new column in the existing table
Example: SELECT *, SUM(sales) OVER() AS total_sales FROM table_name
Functions return a single value while stored procedures execute a set of SQL statements.
Functions are used to perform calculations and return a single value while stored procedures are used to execute a set of SQL statements.
Functions can be used in SELECT, WHERE, and HAVING clauses while stored procedures cannot.
Functions can be called from within stored procedures while stored procedures cannot be called from within ...
ALL function in DAX returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied.
ALL function can be used to remove filters from a table or column.
It can also be used to remove filters from a specific column in a table.
ALL function can be combined with other functions like CALCULATE to perform complex calculations.
Example: CALCULATE(SUM(Sales[Amount]), ALL(Sales[Prod...
Top trending discussions
Visio is a diagramming tool used to create flowcharts, diagrams, and other visual representations of data.
Start by selecting a template or creating a new document
Drag and drop shapes onto the canvas and connect them with lines or arrows
Add text, images, and other elements to enhance the diagram
Use the formatting tools to customize the appearance of the diagram
Save and export the diagram in various formats such as PDF o
I applied via Campus Placement and was interviewed before Oct 2021. There were 2 interview rounds.
Derivatives are financial contracts that derive their value from an underlying asset or security.
Derivatives can be used for hedging or speculation.
Examples include futures, options, swaps, and forwards.
Derivatives can be traded on exchanges or over-the-counter.
Derivatives can be complex and carry significant risk.
Derivatives played a role in the 2008 financial crisis.
Derivatives are financial instruments whose value is derived from an underlying asset or security.
Futures contracts
Options contracts
Swaps
Forwards contracts
Credit derivatives
Interest rate derivatives
Currency derivatives
Commodity derivatives
I applied via Campus Placement and was interviewed before May 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed in Nov 2020. There was 1 interview round.
I applied via Naukri.com and was interviewed in Nov 2020. There was 1 interview round.
I applied via Company Website and was interviewed before Nov 2020. There were 4 interview rounds.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Associate System Analyst
831
salaries
| ₹3 L/yr - ₹13.7 L/yr |
IT Supervisor
224
salaries
| ₹1.2 L/yr - ₹3.6 L/yr |
System Analyst
192
salaries
| ₹5 L/yr - ₹17.5 L/yr |
Associate Test Analyst
186
salaries
| ₹2.5 L/yr - ₹10 L/yr |
Associate
164
salaries
| ₹1 L/yr - ₹7.8 L/yr |
TCS
Infosys
Wipro
HCLTech