Bi developer Interview Questions
688
Bi Developer interview questions shared by candidates
What work have you done? work related and experience related
4 Answers↳
Dod they communicate to yoy about the offer or not then?
↳
No I have followed up many times. They are not answering call... I just asked 5% more than what they were offering... Less
↳
How much increment did they offer?

There is a table named GEO, having state and city as it's attribute! Write a query to select the state having multiple cities in it?
3 Answers↳
Solved it! select state from geo group by state where count(*) > 1;
↳
select state from employee group by state having count(cityname)1
↳
select state from employee group by state having count(cityname)1

What is your profession? Where did you worked? Do you know SQL solution for this ... problem? Are you familiar with databases like ORA, Postgres, etc...?
2 Answers↳
Cite your CV, and show up SQL statements or procedure for the problem.
↳
Can you please tell me what kind of sql statements were they


Puzzle: A coin is in one of the inverted bags. First bag says 'Coin is in third bag', second says: 'There is no coin here' and third says: 'There is no coin here'. Considering one statement is true while two are false, where is the coin?
2 Answers↳
I answered second bag. But, he said it was wrong.
↳
coin is in first bag as: put first statement false i.e. coin is not in third in third bag put third statement true i.e. coin is not in third bag so it's concluded by two statements that coin is not in third bag. now put the second statement true which says coin is not here i.e. coin is not in 2 or 3 bag Less

How to remove duplicate records
2 Answers↳
Use CTE.
↳
or to clarify duplicates into a staging table when you are taking a subset of all the fields and you know what specific fields you are after, INSERT INTO > (>) SELECT > FROM (>) GROUP BY > having count(*)>1 and to add only those that are not duplicates INSERT INTO > (>) SELECT > FROM >) T GROUP BY > having count(*)=1 Less



