---
title: "Group By Clause"  
description: "Group By Clause"  
author: "Anurag Chaurasia"  
published: 2011-05-24  
updated: 2011-05-25  
canonical: https://www.mindstick.com/forum/262/group-by-clause  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# Group By Clause

How we can [fetch](https://www.mindstick.com/forum/156159/what-is-google-fetch) full [table data](https://answers.mindstick.com/qa/114525/how-to-delete-rows-with-reference-table-data) by using [group by clause](https://www.mindstick.com/forum/158904/explain-the-purpose-of-the-group-by-clause-in-sql-and-provide-an-example) without using any [aggregate functions](https://www.mindstick.com/forum/158949/what-are-the-conditional-aggregate-functions-in-sql-such-as-sum-case-and-how-are-they-used) ? Please help me its urgent....

## Replies

### Reply by Anonymous User

Hi.. Anurag

Try following query this might be helpful for you.

select * from Student [group](https://yourviews.mindstick.com/view/81323/adani-green-energy-group-bags-world-s-biggest-solar-bid) by sid,sname,sage,scity.

Simply you will right all name of column of [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) on right side of group by [clause](https://www.mindstick.com/forum/33937/difference-between-throw-exception-and-throw-clause) and you got solution.


---

Original Source: https://www.mindstick.com/forum/262/group-by-clause

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.