• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Newb sql question

Page 2 - Seeking answers? Join the AnandTech community: where nearly half-a-million members share solutions and discuss the latest tech.
Originally posted by: Evadman
My god. This thread makes me cry.

<SQL>
SELECT * from [TableOfEmployees] where [LastNameField] IN (Select [LastNameField] HAVING Count([LastNameField]) > 1)
</SQL>

There are of course other ways to do it.
Click to expand...


Can you do it without a subselect?
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top