in a table it has 200 rows the query is select 150 from
tablename.whats the output
Answer Posted / babu
Hi all,
it is very simple.
if you give any number in the select list it will displays the
that number(how many records table havie that number of times)
Ex: select 200 from tab
Ans:200
200
200
--
--
200(200 times)
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is a filter transformation and why it is an active one?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Which development components of informatica have the highest usage?
What is the difference between router and filter?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Difference between Target-based loading and constraint-based loading?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is substr in informatica?
What are the tasks that can be performed using sq?
Define filter transformation?
difference between repository database and repository service?
How can we delete duplicate rows from flat files?
What is difference between a gateway node and worker node?
Briefly define a session task?