Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What will be the output of below query?
Select Round(rate,0) From Opportunity_Creation;
If Opportunity_Creation contains 2 rows in Rate column as
on 11/29/2013 | Category:
Sql Server Interview questions
| Views: 2319 |
Select from following answers:
Output will be 201.00,101.00.Actually round works as a ceiling function.So even if rate value is 200.50,it rounds it to 201.00.
Show Correct Answer
Many Interviews |
< Previous :
How may ways to change background-color of a Page?
Next > :
What will happen,if we run below query? Select ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
What will happen,if we run below query? Select Round(employee_name, ...
How to execute below stored procedure? create procedure load_employ ...
What will be the output of below query? Select Top 50 * From Employ ...
What will be the output of below query? Select Top 50 Percent * Fro ...
What will be the output of below query? select * from employee_mast ...
What will be the output of below query? select try_parse('111 ...
What is the difference between Finalize and Dispose method in Dot Net?
How to create Table without using Create Statement?
Latest Interview Questions
Which processes implemented sandbox solution?
Which of the following files/programs are not removed by the uninstall ...
What is compatibility level of SQL server 2012?
DBCC SHRINKDATABASE (UserDB, 10); What is the unit of second paramet ...
We can configure individuals to be alerted about sql server agent jobs ...
Which of the following built in tool allows you to changes services ac ...
Which of the following is FALSE regarding the tempdb database?
We can RECOMPILE a stored procedure in SQL server. Which of the follow ...