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
11423 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

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 Answers

Explain syntax for disabling triggers?

0 Answers

What is a mutating table error and how can you get around it?

0 Answers

How to concatenate two character strings together?

0 Answers

Creating Tables Using SELECT

1 Answers

Give an example of SQL injection attack ?

0 Answers HAL,

How to find the version of sql server? : sql server database administration

0 Answers

Can you roll back the ddl statement in a trigger?

0 Answers

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers HCL,

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers

What is the partitioning method?

0 Answers

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers

For more SQL Server Interview Questions Click Here