Pergunta de entrevista da empresa Ellington Management Group

What are the pros and cons of using " SELECT * " in SQL?