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 |
|
transformer
Starting Member
4 Posts |
 Posted - 2011-10-29 : 22:14:42
|
| hi guys,I searched the web and can not find a decent set of complex sQL queries questions, which can be asked in an interview. I request, please help me to find some if you know any useful links. I have no issue with finding nth salary in a table, delete duplicate records, top2 recrods from each group etc.. I wanted something really tough one, included a smart join, a complex subquery etcc. you can also mention/ask a query which u have just come across, if you are suggesting some tough join queries for me then please refer to adventureworks2008 database so that I dont need to create table and populate them first.same is true for normalization stuff, it is very very easy to normalize a employee or invoice/order type of tables, we have been reading about these things from decades now. can you please suggest any other complex scenario where someone really have to think to normalize? I will be grateful for this as I am expecting a rough tech interview from a guy who is Obsessed about sql query and normalization.cheer guys. |
|
|
paultech
Yak Posting Veteran
79 Posts |
|
|
|
|
|
|
|
complex queries and normalization