Fewpal
0 votes
28 views
in Information Technology by (47.6k points)
closed by

Consider the table ‘Employee’.

             ‘Employee’

NameLOcation
GurpreetMumbai
JatinderChennai
DeepaMumbai
HarshChennai
SimiNew Delhi
AnitaBangaluru

Write the SQL command to obtain the following output :

LOcation
Mumbia
Chennai
New Delhi
Bangaluru

1 Answer

+1 vote
by (52.3k points)
selected by
 
Best answer

SELECT DISTINCT (Location) FROM Employee ;

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...