Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SCosta
Starting Member
2 Posts |
 Posted - 2001-03-13 : 12:42:43
|
I saw this question: quote:
Sandeep writes Hi IT Guys, during an interview, a recruiter asked me "How can you retrieve the first n number of fields using sql statement withought using field names?" ex. Table A contains 50 fields and I want to select first 10 fields. I don't want to mention all the 10 fields name. I love these questions!
The thing is that I think the solution given is WAAAAAAAY too complicated. Wouldn't this query work? select top 10 * from table Edited by - SCosta on 03/13/2001 12:44:51 |
|
|
|
|
|
Article