I hav 10 records only one column
1,2,3,4,5......10
now am writing query select max(column name)
Then
What is The Output
Answer Posted / guest
10 because
its return max value of that column .
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Define inner join? Explain with an example?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Define tempdb database?
can a table be moved to different filegroup? : Sql server administration
Using the customer, and order table in northwind database, please write a query to produce xml?
Explain about SQL server 2005?
How can you list all the table constraints in a database?
What is SQL Azure Fabric?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Explain about system database?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
How would you choose between a clustered and a non-clustered index?
Can we delete data from a view?
What is bit data type? What's the information that can be stored inside a bit column?