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

datagridview
NIKHIL Kharat3h ago0
How Are AI Agents Different from Chatbots? (2026 Breakdown)
Laura Bennett14h ago5
How to data fetch login form to order form nane email contact number
Abhishek Jagadale17h ago0
What's the Most Overrated AI Feature?
Rom C21h ago2
How to load 5000 data in Power Apps gallery
Ismail Sayyad21h ago2
What is full-stack data science, and how is it different from traditional data science?
tejasri22h ago3
LINQ and Lambda Expressions
Sangeetha S22h ago3
upload document on server in .net
sagar k2d ago3
How Are You Using AI Coding Agents (Claude Code, Copilot, etc.)
Sudarshan Hajare3d ago1
Error converting data type nvarchar to numeric
David Godistei3d ago2
winform task
Nandini Sonawane4d ago1
Repair MS Outlook PST file issue
Chemline Dorno6d ago2
CrystalDecisions.CrystalReports.Engine
Ramco Ramco8d ago0
Which library is primarily used for numerical computing in Python?
tejasri14d ago1
Best pattern for streaming AI responses into a Blazor Server app without flooding the SignalR circuit?
Aarti Jangid15d ago0
How Can AI Data Engineering Improve Data Quality and RAG Application Performance?
Aarti Jangid16d ago0
How to Prevent Sensitive Data Exposure in AI Workflows
Rom C16d ago0
What is RAG in Generative AI?
tejasri20d ago4
add code snippet
Priya Prajapati22d ago2
about azure app service
jahnavi charakani23d ago0

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.

Write a single query in sql to calculate total salary

Home
Forums

Write a single query in sql to calculate total salary

Mohammad Aman

Mohammad Aman

10yAsked Oct 4, 2016, 2:34 AM2.7k

I want to write a single SQL Query to show the output just like :

Name Salary Total

Sonu 5000 5000

Monu 10000 15000

Ramesh 20000 35000

I am also attaching the image , but i need a single sql query

2 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

Midhun Tp10y ago
Accepted answer
Hi,
Try below query -
select a.srno, a.employeename,a.salary, sum(b.salary) as total
from employee a cross join employee b
where b.srno <= a.srno
group by a.srno, a.employeename,a.salary ORDER BY srno ASC
0
Nitin Sontakke10y ago
Depending on which version of SQL Server you are using, you can also use ranking functions.
0