Which of the following is not an Aggregate function?
Correct Answer: LEN()
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Microsoft SQL Server Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Microsoft SQL Server MCQ Questions
Consider the following query: Select name from employees where name like '%_n_' Which names will be displayed?
You want to select a row using cursors in the table 'qlist'. Which of the following statements DECLARES a cursor 'qselect' to perform the desired operation?
Which query will be used for a particular column of a table, if 'Reading' is to be replaced by 'Writing'?
How is the following query incorrect? select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)
Which data type in the SQL SERVER 2005 converts itself into the type of data that is inserted into it?
A relationship that identifies that a column contains primary key values from another table is referred as what?
'SELECT name FROM t1 UNION SELECT name FROM t2 ' is the same as 'SELECT DISTINCT name FROM t1 UNION ALL SELECT DISTINCT name FROM t2'
Which of the following is NOT an aggregate function in SQL Server?
'SELECT UNIQUE city FROM customers' will return what data set?
True or False? The EXEC keyword and the EXEC() function are equivalent to each other.