Answer / Pooja Rani Vishnoi

A sub-query, also known as an inner query, is a SQL statement that is nested inside another SQL statement. It can return a single value or multiple values. Sub-queries can be used to filter data, join tables, aggregate data, and perform complex queries. There are two main types of sub-queries: correlated sub-queries and non-correlated sub-queries.

what's new in sql server 2016?

1 Answers  

---

Write an sql query to find first weekday of the month?

1 Answers  

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

What is the difference between set and select?

1 Answers  

---

What is similarity and difference between truncate and delete in sql?

1 Answers  

---

What is difference between sql and sql server?

1 Answers  

---

What are the advantages of using third-party tools?

1 Answers  

---

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

What are user defined functions in ms sql server?

1 Answers  

---

What is optimistic concurrency?

1 Answers  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---