I hav 10 records only one column 1,2,3,4,5......10 now am writing query select

Categories >> Software >> Databases >> SQL Server
Suggest New Category

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

Question Posted / sai

9 Answers
11190 Views
Brigade, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / shyamsri83

The Maximum column value will be the output.
10

Is This Answer Correct ?

30 Yes

0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / bhagat

output will be 10.

Is This Answer Correct ?

14 Yes

0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / sudhakar

10 because
its return max value of that column. interviewer wants to
check you r confidance so thats he confused you .

Is This Answer Correct ?

5 Yes

0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / deekshith reddy

Is This Answer Correct ?

3 Yes

0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / ravikumarayyapu

Output is 10.

Is This Answer Correct ?

3 Yes

0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / guest

10 because
its return max value of that column .

Is This Answer Correct ?

2 Yes

0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / guest

10 because
its return max value of that column .

Is This Answer Correct ?

2 Yes

0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / dhiraj

10 because
its return max value of that column.

Is This Answer Correct ?

2 Yes

0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / swapna

The output is 10

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More SQL Server Interview Questions

List the different normalization forms?

0 Answers

What are the 10 characteristics of data quality?

0 Answers

How to convert character strings into numeric values?

0 Answers

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 Answers

What is database dimension? : sql server analysis services, ssas

0 Answers

Do you know how to store and query spatial data?

0 Answers

What happens to a statement batch if there is a compilation error?

0 Answers

How do I port a number to sql server?

0 Answers

can any one say how to update the following senario I have a table <srabank> in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <accountno> <31518746291> the balance is <4000> for the <accno> <31518746292> the balance is <14000> after transferring the balance the details will look as follows <accno><31518746291> <bal> <2000> <accno><31518746292> <bal> <16000> the above mentioned two statment will come under the final result.

3 Answers

Explain what are the database objects? : SQL Server Architecture

0 Answers

How to invoke a trigger on demand?

0 Answers

What is scrollable cursor?

0 Answers

For more SQL Server Interview Questions Click Here