SQL Server Interview Questions
Questions Answers Views Company eMail

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

Indecomm,

7 3735

write a query to remove duplicate records without using primary key column?

ABCO,

2 6655

What Is The Difference Between Primary Key & Super Key

Accenture,

3 4494




I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

Wipro, HCL,

1182

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 4607

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 3165

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

970

what is Equity join?

ADP,

2 3956




How to get number of days in a given year?

ADP,

4 3794

Differencr Between DELETE and TRUNCATE?

ADP,

3 4056

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 3135

How to get number of days in a given year?

ADP,

4 4786

Explain SELF JOIN ?

ADP,

3 4069

What is Index ? Explain its Types?

ADP,

2 4996

Define Foreign Key?

ADP, College School Exams Tests,

3 5614


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

your distribution database is full what will u do

1033


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2839


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1119


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

945


Why we need to use secondry database file? though, we can do same work using primary database file also.

4373






how to overcome kernel isssues

529


Delete duplicate rows without using rowid.

267


How to restore performance issues and how to check?

918


ow to bring suspect mode datbase online from scratch

759


What are the dis_advantages of stored procedures, triggers, indexes?

1046


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

860


how many no of arguments can be passed in procedures and functions

3633


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

887


What is RMS migrations?

1035


This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

1329