986Questions
785Answers
Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

What are some options to randomly capture a value from a column in a table?

Nice?Vote!
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)

1 Answer

Nice?Vote!
*    RAND() function
*    NEWID() function
*    TABLESAMPLE function
answered 1 year ago by R (19,530 points)

Related questions

Nice?Vote!
3 answers
What is an identity? What is the value? How can you capture the last identity value per column?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
Name 3 or more aggregate functions and the value they provide in your coding.
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
What are the different indexing options available and what columns do you typically index?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
2 answers
What is the importance of primary keys and foreign keys in a SQL Server OLTP database design?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
5 answers
What is the difference between DDL and DML commands? Can you name some examples of each?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Powered by Question2Answer