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 |
|
testingcareer.kpc
Starting Member
2 Posts |
 Posted - 2011-02-14 : 06:15:39
|
| Hi ,Can anyone help me in answering the below questions on SQL :SQL Queries :1)I have two tables :COuntry,city I want all the cities in each country.Question on Cross Join.2) I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.3) There are three tables :E : EID,ENAMED : DID,DNAMEempdept : eid, didselect the employees who doesn't belong to any dep4)Discussion on Except ,using cast like type cast. Question in the context of difference between two tables5) There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key.In other words how do you get the duplicate records.Regards,Prasad |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-02-14 : 06:22:37
|
| What have you tried so far?MadhivananFailing to plan is Planning to fail |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-02-14 : 07:55:45
|
| Were those questions asked at Microsoft ?PBUH |
|
|
|
testingcareer.kpc
Starting Member
2 Posts |
Posted - 2011-02-16 : 07:19:21
|
quote:
Originally posted by madhivanan
What have you tried so far?MadhivananFailing to plan is Planning to fail
I tried this :I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.select depid,max(sal) from <table name> group by depid; |
|
|
|
tra072011
Starting Member
1 Post |
Posted - 2012-08-18 : 00:03:01
|
| HiYou can find this info by using search box in the top of website with some keywords related before posting questions.If you want to get more materials that related to this topic, you can visit: Microsoft interview questionsBest regards.http://interviewquestionstoask.info/microsoft-interview-questions/ |
|
|
|
|
|
|
|
|
Microsoft Interview Questions