Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

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.

Attendance Database

Home
Forums
SQL

Attendance Database

Ahmed ALMaqbali

10yAsked Sep 22, 2016, 2:02 AM861SQL

i have data like this

i need query to get me like this output

Attend_Device	Attend_User_ID	Attend_DATE	TIME_IN	TIME_OUT
RD1	832	29/09/2015	07:40:45	14:30:45
RD1	833	29/09/2015	07:40:45	14:30:45
RD2	834	29/09/2015	07:40:45	Null
RD2	835	29/09/2015	Null	14:30:45

Thank

Ahmed

1 Reply

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

Bikesh Srivastava10y ago
some fields are not cleared .
1.Attend device
2.time in
3.time out
where is these.?????????
0