What is the use of partition by in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is a print index?
What is deadlock and how to avoid the deadlocks.
How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)
10 Answers Cognizant, Infosys,
what are the different ways to return the rowcount of a table?
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
What is bit datatype and what's the information that can be stored inside a bit column?
If we use where clause in the left outer join then how the query would behave/act?
Explain the different types of joins?
How to create new tables with "create table" statements in ms sql server?
Explain sp_configure commands, set commands?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?