SQL Server Questions & Answers

Which SQL statement is used to return only different values?

A) SELECT DISTINCTB) SELECT INDENTITYC) SELECT DIFFERENTD) SELECT UNIQUE

SQL Server

1 Answer · 910 Views · Answered ✓

A Asked by: Aashna Saito · 5 years ago

When should we use EXISTS, and when should we use IN?

SQL Server

1 Answer · 288 Views · Answered ✓

B Asked by: Ben PHILLIPS · 5 years ago

What is the difference between the EXISTS and IN clause in SQL?

SQL Server

1 Answer · 846 Views · Answered ✓

A Asked by: Arun Sharma · 5 years ago

Properties in C#

I have a couple of properties in C# which are double and I want to store these in a table in SQL Server, but noticed there is no double type, so what…

SQL Server

1 Answer · 991 Views · Answered ✓

B Asked by: Bhaanumati shukla · 5 years ago

Is it possible to query for table names which contain columns being LIKE '%myName%'

SQL Server

1 Answer · 1.1K Views · Answered ✓

Y Asked by: Yash raj · 5 years ago

Can anyone tell me how to calculate time difference in hours and minutes in SQL Server?

SQL Server

1 Answer · 745 Views · Answered ✓

D Asked by: Deepali singh · 5 years ago

How to remove leading zeros from a field in a SQL statement ?

I am working on a SQL query that reads from a SQLServer database to produce extract files. We are required to remove the leading zeros from a…

SQL Server

1 Answer · 2.4K Views · Answered ✓

R Asked by: Ranjana Admin · 5 years ago

SQL query for finding records where count > 1

I have a table named PAYMENT. In this table, I have a user ID, an account number, a ZIP code, and a date. I would like to find all records for all…

SQL Server

1 Answer · 1.7K Views · Answered ✓

R Asked by: Rachit Gupta · 5 years ago

How do I get the java resultset size?

Searched a lot but did not find a size() nor length() method.

SQL Server

1 Answer · 294 Views · Answered ✓

B Asked by: Brian Kennedy · 5 years ago

How do I query in SQL for getting the latest record date for each user ?

I have a SQL table that is a collection entry as to when a user was logged on.username, date, value--------------------------brad, 1/2/2010, 1.1fred,…

SQL Server

1 Answer · 1.0K Views · Answered ✓

A Asked by: Aditi Ishii · 5 years ago

What is the difference between spark.sql.shuffle.partitions and spark.default.parallelism?

SQL Server

1 Answer · 1.6K Views · Answered ✓

A Asked by: Andrew Jenkins · 5 years ago

SQL query to select dates between two dates

I have a start_date and end_date. I want to get the list of dates in between these two dates. Would anyone like to help me pointing out the mistake…

SQL Server

1 Answer · 1.5K Views · Answered ✓

R Asked by: Rahul verma · 5 years ago