I have made a table employee where are 2 employee having same designation what command or query i should use to show name & id

Question

Fast reply please

Answer 1

Disha Dey
Describe the tables structure in the original question Description above. People don't know the structure of your tables (nor relationship), so it's hard to help you effectively.

Answer 2

SELECT name, id FROM employee

Answer 3

Query didn't worked