Write a single query in sql to calculate total salary

Question

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

Midhun T P · Answer

Hi Try below query - select a.srno a.employeenamea.salary sum(b.salary) as total from employee a cross join employee b where b.srno group by a.srno a.employeenamea.salary ORDER BY srno ASC

Nitin Sontakke · Answer

Depending on which version of SQL Server you are using you can also use ranking functions.