Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Which statement is correct to display FruitNames of the table(Fruit) in ASCENDING ORDER?
on 9/6/2013 | Category:
.NET Framework Interview questions
| Views: 4606 |
Select from following answers:
SELECT FruitName FROM Fruit
SELECT FruitName FROM Fruit GROUP BY FruitName
SELECT FruitName FROM Fruit ORDER BY FruitID
GROUP BY clause internally orders(sorts) the result set.. Most of the interviewers will frequently ask this kind of logical questions...
By looking at answers set obviously users will select 3rd one as answer.. Before answering a question we should be very careful.
Here 3rd is incorrect answer because final result will be based on FruitID, but not FruitName
Show Correct Answer
Many Interviews |
< Previous :
How to do custom sorting in SQL Server?
Next > :
Difference between PARSE() and TRY_PARSE() functio ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Difference between PARSE() and TRY_PARSE() functions
Latest Interview Questions
You are creating a custom product class. You want to ease the conversi ...
You want to determine whether the value of an object reference is deri ...
Your developed web app creating a custom exception called LogonFailedE ...
Your developed web application code catches an IOException when a file ...
You are checking the arguments of your method for illegal null values. ...
You are processing some data from over the network. You use a HasNext ...
You have a list of dates. You want to filter the dates to the current ...
You are using a multicast delegate with multiple subscribers. You wa ...