Explain basic SQL queries with SELECT from where Order By,
Group By-Having?

Answers were Sorted based on User's Feedback



Explain basic SQL queries with SELECT from where Order By, Group By-Having?..

Answer / swapna

Order by clause is used to sort information of a table into
specific order either ascending or descending order.

syntax:select stmt order by column;

ex:select * from emp order by sal;

Group by clause is used to divide entire group into
subgroups based on the common values columns.we can use
group by clause along with group functions.

syntax:select group by(exp 1),group by(exp 2),....from
table name group by column name;
select max(sal),min(sal) from emp group by deptno;
Group by clause can allow where clause.


Having:is used to restrict information of the atble based
on condition.

syntax:select group by (exp 1) ,group by (exp 2) from table
name group by column having (condition).

Having and Group by clauses can interchange their positions.

but when using having along with order by clause having
should be placed before order by clause.

Is This Answer Correct ?    25 Yes 4 No

Explain basic SQL queries with SELECT from where Order By, Group By-Having?..

Answer / ranjan

In above select stmnt city must be in group by clause. Otherwise it'll sho error.

Is This Answer Correct ?    3 Yes 1 No

Explain basic SQL queries with SELECT from where Order By, Group By-Having?..

Answer / nitin

sory i m satisfied with idea.actualy i want to know is this
query is right or not.plz inform me.

SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC

Is This Answer Correct ?    7 Yes 19 No

Post New Answer

More SQL Server Interview Questions

What types of Joins are possible with Sql Server?

0 Answers   NA,


Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  


How many categories of data types used by sql server?

0 Answers  


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  


What is the difference between a primary key and a unique key? Are they the same?

0 Answers  






What is the use of sql profiler in sql server 2012?

0 Answers  


What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  


Explain tablesample?

0 Answers  


Tell me when is the update_statistics command used?

0 Answers  


Explain contrast amongst grouped and non-bunched records?

0 Answers  


How much memory that we are using in Logshipping Concept?

0 Answers  


How do you create a data source?

0 Answers  


Categories