What is the use of subquery?

1.	What is the use of subquery?
Answer» Subqueries provides you a more flexible option to filter the data as compared to an ordinary query filter. Using Subqueries you can limit the values returned with a WHERE clause. You can also compare the values of objects in a subquery with the other objects. Using Subqueries, you can implement complex logic to limit the size of data which are not possible to apply with simple query filters. They are used in Query panel.

Answer»

Subqueries provides you a more flexible option to filter the data as compared to an ordinary query filter. Using Subqueries you can limit the values returned with a WHERE clause. You can also compare the values of objects in a subquery with the other objects.

Using Subqueries, you can implement complex logic to limit the size of data which are not possible to apply with simple query filters.

They are used in Query panel.

Discussion

No Comment Found

Related InterviewSolutions

What do you understand by input controls? Can we use input controls on Geography and Time hierarchy?
In a Webi report, you want to add Radio buttons for end users to quickly view and analyze the data. Which of the Webi feature support this?
You have saved a Webi Report .wid file and send it to other user to make changes. He is not able to open it and getting access error. How you can resolve this?
Can you attach a Webi document in mail?
How do you connect SAP HANA database to Webi document?
To allow sync between two queries in Query merger, you use a new variable to add it to report. What re properties that you need to define to enable sync?
How do you create a hyperlink in the Web Intelligence Interactive panel?
What is the use of Nofilter() function?
What is use of string concatenation?
What is an input context?

What is the use of subquery?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment