Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

CSharp TV
Videos
Tech
Articles
Blogs
News
Forums
Books
Events

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Latest Forum Questions

Can I recover SQL Server database records along with the documents stored in them?
samaira4h ago3
about azure app service
jahnavi charakani14h ago1
add code snippet
Priya Prajapati14h ago3
What is RAG in Generative AI?
tejasri14h ago5
How to data fetch login form to order form nane email contact number
Abhishek Jagadale14h ago2

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to write the query for my output

Home
Forums
Visual Basic .NET

How to write the query for my output

narasiman rao

14yAsked Nov 26, 2012, 3:34 AM3.4kVisual Basic .NET

EMP Table AS Follows;

EMPID EMPNAME MGRNo MGRNAME

1 Raj Null RAvi

2 Ram 1 Sam

3 Hari 2 Yogi

from the above EMP Table i wan the output as follows;

I want the output

EMPID EMPNAME MGRNAME

1 Raj RAvi

2 Ram Sam

3 Hari Yogi

For that how to write the query in sql server.please help me. uisng sqlserver

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Satyapriya Nayak14y ago
If your problem is solved please click the checkbox(This is correct answer)

Thanks
0
venkata kumar14y ago
hi

SELECT EMPID,EMPNAME,MGRNAME FROM EMP

Thanks & Regrads
Kumar
0
Vishnujeet Kumar14y ago
select EMPID,EMPNAME,MGRNAME from EMP
basic sql you can learn below link..
http://www.w3schools.com/sql/default.asp
0
Pradip Pandey14y ago
Select EMPID, EMPNAME, MGRNAME From EMP
GO

Hope it will help.
0