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 / dhiraj
10 because
its return max value of that column.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What objects does the fn_my_permissions function reports on? : sql server security
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Can we add a cpu to sql server?
What is self contained multi valued query?
What is difference between clustered and non clustered index?
How do I start sql server?
how you can list all the tables in a database?
Explain partitioned view?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How to select all columns of all rows from a table with a select statement in ms sql server?
What are commonly used odbc functions in php?
How to provide default values to stored procedure parameters?
Why use cursor in sql server?
Ms sql server index?
What is the difference between value type and reference type?