sub-query Image

sub-query

question
MATHEWSM avatar image
MATHEWSM asked Default

I want to list users that have normal User Access and must also list the groups relevant to each user. this is on two different database [cheeter( has SecurityUserGroupLink [wGroupID & wUserID])] and [GameRanger(has securitygroup [wGroupID & szName])]

select sub-query

0 Likes

0Answers

0 Comments

question
umar001 avatar image
umar001 asked Default

Common table expression or sub query

sub-query common-table-expression

0 Likes

0Answers

0 Comments

question
WRBI avatar image
WRBI commented Default

Correlated Sub-query with Max - Sql Server 2014

sub-query max correlated

0 Likes

0Answers

1 Comment

question
Jon Crawford avatar image
Jon Crawford answered Default

How do I write this query?

sql query mysql sub-query help

0 Likes

1Answer

1 Comment

question
SQLcuriosity avatar image
SQLcuriosity answered Default

Complicated problem with temp table column aliases used in a subquery

sub-query temporary-table alias

This question has an accepted answer. Accepted

1 Like

2Answers

0 Comments

question
Shohel avatar image
Shohel answered Default

SQL Northwind Database Query Question Closed

sub-query

0 Likes

2Answers

0 Comments

question
Kev Riley avatar image
Kev Riley answered Default

SQL Query help

sub-query

0 Likes

3Answers

0 Comments

question
sp_lock avatar image
sp_lock commented Default

Trying to get highest paid employee in departmen 'd01'

sql-server-2008 sql query sub-query max

0 Likes

3Answers

0 Comments

question
GPO avatar image
GPO edited Default

How Do I Subquery this?

aggregates sub-query

0 Likes

1Answer

0 Comments

question
JohnM avatar image
JohnM commented Default

How to exclude certain records which repeat in next row with different condition?

sql query sub-query record

0 Likes

0Answers

1 Comment

question
Gazz avatar image
Gazz answered Default

Find Matching rows and Rank them

sql cte sub-query ranking

0 Likes

1Answer

0 Comments

question
Tom Staab avatar image
Tom Staab commented Default

Surely there must be a better way of doing this query?

stored-procedures tsql sub-query

This question has an accepted answer. Accepted

1 Like

2Answers

1 Comment

question
David 2 1 avatar image
David 2 1 commented Default

CASE Statement Within Subquery

sql-server-2000 tsql sub-query case-statement

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
hstarkar87 avatar image
hstarkar87 answered Default

Which is better? CTEs (common table expressions) or Subqueries?

cte best-practice sub-query common-table-expression

This question has an accepted answer. Accepted

6 Likes

7Answers

0 Comments

question
Tiff5282 avatar image
Tiff5282 answered Default

Write a sub-query that returns employees who did not place orders on or after May 1st, 1998. Include the employeeid, last and first names

sql sub-query order-by

This question has an accepted answer. Accepted

0 Likes

2Answers

1 Comment

58 Posts
51 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.