Interested to Buy Any Domain ? << Click Here >> for more details...
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day.
SOURCE_PHONE_NUMBER
DESTINATION_PHONE_NUMBER
CALL_START_DATETIME
1234
4567
01/07/2011 10:00
1234
2345
01/07/2011 11:00
1234
3456
01/07/2011 12:00
1234
3456
01/07/2011 13:00
1234
4567
01/07/2011 15:00
1222
7890
01/07/2011 10:00
1222
7680
01/07/2011 12:00
1222
2345
01/07/2011 13:00
Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different.
Desired Output:
Source Number
Is_Match
1222
N
1234
Y
- 2 Answers
- 9151 Views
- Amazon, I also Faced
- E-Mail Answers
Answer Posted / kivi
first value and last value...
for more info ref
http://etltechsolutions.wordpress.com/2014/10/12/last_value-and-first_value-best-example/
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What the difference is between a database, a data warehouse and a data mart?
Implementation methodology
What is rank transformation in informatica
Tell me about MD5 functions in informatica
Which are the different editions of informatica powercenter that are available?
Explain scd type 3 through mapping.
whats the logic to load the lower level of granularity of data to fact table.
How might you approve all mappings in the archive all the while?
r u done any partitions in ur project?
write a query to retrieve the latest records from the table sorted by version(scd)
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the cumulative sum and moving sum?
What is the meaning of decode in informatica?
What is the difference between stop and abort in informatica
What is Cognos script editor?
