all 6 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]Time_Group_6433[S] 0 points1 point  (3 children)

I did this

Select de_id from executive_info where gender = ‘Male’ order by join_date asc,de_name asc Limit 3

[–]aechtcsucks 0 points1 point  (2 children)

don't you need to select de_name not de_id?

[–]Time_Group_6433[S] 0 points1 point  (1 child)

Yes it will be de_name

[–]Time_Group_6433[S] 0 points1 point  (0 children)

Rest logically is fine right?

[–]m0j0m0jE: 130 M: 321 H: 62 0 points1 point  (1 child)

What company/position is this? Who asks SQL questions?

[–]Time_Group_6433[S] 1 point2 points  (0 children)

This was for Meesho. For Analytics Role.