Click here to Skip to main content
15,352,155 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
Suppose we have a requirement to fetch a record on basis of a condition.

select records from the table on the basis of where clause and sort them by group by clause.

Normally we used to code it like

select first_name,salary
from table1
where salary>10000 --optional
group by first_name,salary;

What I have tried:

select cool1,col2
from table
where condition --optional
group by col1,col2;
Updated 3-May-22 0:57am

1 solution

Probably teh best thing to do is start here: Analyze an Actual Execution Plan - SQL Server | Microsoft Docs[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900