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 3467

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

ABCO,

2 6382

What Is The Difference Between Primary Key & Super Key

Accenture,

3 4300




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,

1072

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 4406

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 2954

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

846

what is Equity join?

ADP,

2 3763




How to get number of days in a given year?

ADP,

4 3547

Differencr Between DELETE and TRUNCATE?

ADP,

3 3840

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 2949

How to get number of days in a given year?

ADP,

4 4564

Explain SELF JOIN ?

ADP,

3 3853

What is Index ? Explain its Types?

ADP,

2 4695

Define Foreign Key?

ADP, College School Exams Tests,

3 5392


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How retrieve field names from the table in SQL through JAVA code?

672


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

852


How to restore performance issues and how to check?

813


Delete duplicate rows without using rowid.

156


what is the sql equivaent of the dataset relation object ?

807






OPTIMIZATION OF SP,CURSOR,TRIGGERS

1479


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1235


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

1016


What is RMS migrations?

922


How can we call UDF(User Define Function) using C# code in ASP.net ?

4627


how can u get last observation in an unknown dataset ?

1106


query processing

975


sql database suspect We have a sql database that is showing as suspect. How can we recover?

687


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

772


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

4175