| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..
1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..
| Rolta | 5 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| Explain sp_configure commands, set commands? | | 3 |
| I have student marks in a student table. I need second
highest mark .Then what will the query for this? | Wipro | 23 |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| how we can count records as a group of days like sum of
records for(four mondays),(four tuesday)........ in a month.
group the column for weekdays.
| | 1 |
| what is the cursor life span? | Evalueserve | 5 |
| What are the type of Indexes? which one is best, why? | | 5 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| how to rest identity columns in sql server | Matrix | 3 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| What is the datatype returned by count(*) | Asian-CERC | 18 |
| could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.
3.What is computed columns?
Thanks in advance.
Regards,
Rupesh
| | 3 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| which one will take 1st priority in case of insert statement
and select statement??? | | 2 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| what is the main difference between after trigger and
instead trigger. | | 1 |
| How do we rollback the table data in SQL Server | | 3 |
| can anyone explain me the concept of Serialization in Detail
and Clear? plz its urgent i have interview on friday (15th feb) | | 1 |
| what is diffence between replicaion and logshipping? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
