Interview Question

BI Developer Interview

-

Polestar Solutions & Services India

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?

AnswerAdd Tags

Interview Answers

3 Answers

0

Solved it! select state from geo group by state where count(*) > 1;

Anonymous on

0

select state from employee group by state having count(cityname)1

Anonymous on

0

select state from employee group by state having count(cityname)1

Anonymous on

Add Answers or Comments

To comment on this, Sign In or Sign Up.