sql server query interview questions - answers with example for fresher _ set-1 solution ~ interview...

2/22/2015 SQL SERVER QUERY INTERVIEW QUESTIONS - ANSWERS WITH EXAMPLE FOR FRESHER : SET-1 SOLUTION ~ INTERVIEW QUESTI

http://www.interviewquestionspdf.com/2014/07/sql-server-query-interview-questions_13.html 1/9

INTERVIEWQUESTIONS

PDF

SQL SERVER QUERY INTERVIEW QUESTIONS -ANSWERS WITH EXAMPLE FOR FRESHER : SET-1 SOLUTION

HOME FREE PDF

SQL SERVER INTERVIEW QUERY SET : 1 WITHANSWERS/SOLUTION

Here I come with more than 100 SQL Server queriesfor Database/.NET/SQL Server developers, Soon youwill get more than 100 SQL query set in pdf/ebook

format. So keep visiting this page.This is for both fresher and experienced developers whichwould be helpful for Interview preparation.First try to answer these queries and put comment. Afterthat see the answers of each query in solution set. Tables:-

SQL SERVER INTERVIEW QUERY FOR FRESHER SET : 1SOLUTION

--1. Write a query to get all employee detail from

"EmployeeDetail" table

--ANS:

3

Share



SELECT * FROM [EmployeeDetail]

--2. Write a query to get only "FirstName" column

from "EmployeeDetail" table

--ANS:

SELECT FirstName FROM [EmployeeDetail]

--3. Write a query to get FirstName in upper case as

"First Name".

--ANS:

SELECT UPPER(FirstName) AS [First Name] FROM

[EmployeeDetail]

--4. Write a query to get FirstName in lower case as

"First Name".

--ANS:

SELECT LOWER(FirstName) AS [First Name] FROM

[EmployeeDetail]

--5. Write a query for combine FirstName and LastName

and display it as "Name" (also include white space

between first name & last name)

--ANS:

SELECT FirstName +' '+ LastName AS [Name] FROM

[EmployeeDetail]



--6. Select employee detail whose name is "Vikas"

--ANS:

SELECT * FROM [EmployeeDetail] WHERE FirstName =

'Vikas'

--7. Get all employee detail from EmployeeDetail

table whose "FirstName" start with latter 'a'.

--ANS:

SELECT * FROM [EmployeeDetail] WHERE FirstName like

'a%'

--8. Get all employee details from EmployeeDetail

table whose "FirstName" contains 'k'

--ANS:


'%k%'

--9. Get all employee details from EmployeeDetail

table whose "FirstName" end with 'h'

--ANS:


'%h'

--10. Get all employee detail from EmployeeDetail

table whose "FirstName" start with any single

character between 'a-p'

--ANS:


'[a-p]%'

Click on the following link for NEXT SET OF QUESTIONS:



Related Posts:

SQL SERVER 2012 : SSRS EBOOK PDF FREEAre you searching SQL server reporting services tutorial or ebookpdf. Then this is right place for you. EBOOK NAME : - SQL Server2012 Tutorials: Re Read More

TOP 10 SSIS INTERVIEW QUESTION WITHANSWER FREE PDF DOWNLOADHey are you want to download SSIS interview questions pdf. freeof cost? Then this post for you. But one thing is that this pdfcontaining small set Read More

MS SQL SERVER COMPLEX INTERVIEW QUERY| CARToday I came with complex Sql server Query, You can face thisquery in interview but not in case of fresher sql server interview,It can be asked to Read More

SQL Interview: How to Insert value in identitycolumn in SQL Server 2012Most Important SQL Server Interview Question... How to Insertvalue in identity column manually/forcefully? This is the scriptwhich will describe Read More

SQL SERVER 2014 PDF EBOOK FREEDOWNLOAD : BY MICROSOFTHey good news for SQL Server developers, Microsoft published afree book of SQL Server 2014. If you want to know new featuresof SQL Server 2014 then Read More

Share This: Facebook Twitter Google+ Stumble Digg

CLICK HERE FOR NEST SET (MORE THAN 100 QUERIES)Sponsored Ads

21:58 INTERVIEW QUESTIONS, SQL INTERVIEW QUERY, SQL SERVER 2 COMMENTS

Download PDF SQL Server Download Free PDF Books

3

Share

+1 Recommend this on Google



Newer Post Older PostHome

2 comments:

Enter your comment...

Comment as: Google Account

Publish Preview

Anonymous 20 January 2015 at 01:21

very useful for me

Reply

prabhakar007 28 January 2015 at 03:37

Very useful for me

Reply

Havent TriedTest Studio

Telerik Is First To Support LatestTechnologies & Browser Versions

telerik.com/teststudio

Search SEARCH

Download Books Questions and Answers Movie Download Free



Find us on Facebook

Interviewquestionspdf.com

40 people like Interviewquestionspdf.com.

Facebook social plugin

Like

WHAT IS AN INTERVIEW? :)

MUST READ

CHETAN BHAGAT BOOK/NOVEL HALFGIRLFRIEND FREE DOWNLOAD PDFHINDI/GUJARATI

FREE DOWNLOAD HALF GIRLFRIEND CHETANBHAGAT NEW BOOK/NOVEL 2014 PDF

CHETAN BHAGAT'S HALF GIRLFRIEND HINDIONLINE READ EBOOK PDF

MS SQL QUERIES INTERVIEW QUESTIONS ANSWERSEXAMPLES 4 FRESHER AND EXPERIENCED PDF

SQL SERVER QUERY INTERVIEW QUESTIONS -ANSWERS WITH EXAMPLE FOR FRESHER : SET-1SOLUTION

COMPLEX JOINS : SQL SERVER JOINS QUERIESINTERVIEW QUESTIONS AND ANSWERSEXAMPLES FOR EXPERIENCED SET-7

CHETAN BHAGAT HALF GIRLFRIEND FREEDOWNLOAD +FLIPKART +PDF

Your Dreams are Mine Now PDF FREEDOWNLOAD? NOW GET HARD COPY FREE!! YES!!

Popular Posts



ASP.NET MVC INTERVIEW QUESTION PDF BOOKFREE BY Shailendra Chauhan

Follow us on Facebook

Blog links

Powered by Blogger.

2015 (48)

2014 (138)

December (10)

November (9)

October (5)

September (38)

August (11)

July (19)

Big Data FREE webinar on career opportunities in B...

10000startups.com google initiatives India

CWG 2014 RESULT APPS ANDROID | ITUNES |WINDOWS

GLASGOW CWG 2014 MEDAL TALLY | HARYANA &PUNJAB

HARYANA AND PUNJAB AT CWG 2014 GLASGOW

Schedule of Indian players at the CWG Glasgow 2014...

FREE PDF DOWNLOAD : ANKIT FADIA SOCIAL 50WAYS TO ...

Blog Archive



SELECT QUERIES: Small Tricky SQL SERVER QueriesIn...

MS SQL QUERIES INTERVIEW QUESTIONS ANSWERSEXAMPLE...

DDL : MS SQL SERVER QUERIES INTERVIEWQUESTIONS FO...

COMPLEX JOINS : SQL SERVER JOINS QUERIESINTERVIEW...

JOIN : SQL JOIN QUERIES INTERVIEW QUESTIONSAND AN...

Free Download PDF: ASP.Net, C#.Net, ADO.Net, MS SQ...

GROUP BY : SQL INTERVIEW QUERIES QUESTIONSAND ANS...

SALARY : SQL INTERVIEW QUERIES EXAMPLES FORFRESHE...

DATETIME : SQL SERVER QUERIES INTERVIEW FOREXPER...

SQL SERVER INTERVIEW QUERY WITH EXAMPLE 4FRESHER ...

SQL SERVER QUERY INTERVIEW QUESTIONS -ANSWERS WIT...

Import Data from Multiple Excel Files\Folders usin...

June (7)

May (19)

April (19)

February (1)

Enter your email address:

SUBSCRIBE

Delivered by FeedBurner

Get FREE EBOOK in UR mail-box



Copyright 2015 INTERVIEW QUESTIONS PDFDistributed By My Blogger Themes | Blogger Theme By PremiumBloggerTemplates

Live Traffic Feed

Real-time view Get Feedjit

A visitor from India viewed SQL SERVER2012 : SSRS EBOOK PDF FREE ~ ... 0secs agoA visitor from Dar Es Salaam, Tanzania,

sql server query interview questions - answers with example for fresher _ set-1 solution ~ interview...

Documents