Does order by actually change the order of the data in the tables or does it just change the output?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  


What are the different authentication modes in sql server?

0 Answers  


Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  


Explain nested trigger in sql?

0 Answers  






Can you tell me about the concept of ER diagrams?

0 Answers  


Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,


What is the sql profiler?

0 Answers  


wat new abt truncate in sql server

2 Answers   HCL, HP,


Explain about merge replications?

0 Answers  


What is difference between count (*) and count 1?

0 Answers  


What is a group function explain with an example?

0 Answers  


Categories