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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Queries asked in Job Interview

Author  Topic 

javabuddy
Starting Member

4 Posts

Posted - 2010-10-16 : 05:48:21
Hi Guys,

I am compiling queries which generally asked in job interview , Can I ask you guys to help me and share some queries which will help job seeker to understand the level and difficulty and flavor of those queries.

would be grateful if you could also suggest some ways to solve those query ,from Interview perspective I always prefer to have multiple ways to solve queries.

Samples.

1) Finding second highest salary of an employee ?
2) How to find duplicate employee in table ?

Thanks
Javin

http://javarevisited.blogspot.com/

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-10-16 : 06:00:36
So you want to help people cheat their way through an interview and get a job they're not qualified for?

A list of questions is not going to get anyone through an interview. A competent interviewer can tell the difference between someone who has memorised answers and who knows the material.

Relax. Don't exaggerate your abilities. Don't lie. Don't be afraid to say 'I don't know', but have a plan for finding out.


--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -