Styjun

Can my 2 children, aged 10 and 12, who are US citizens, travel to the USA on expired American passports?

In "Avengers: Endgame", what does this name refer to?

Meaning of the (idiomatic?) expression "seghe mentali"

Is any special diet an effective treatment of autism?

Can the Tidal Wave spell trigger a vampire's weakness to running water?

Piano: quaver triplets in RH v dotted quaver and semiquaver in LH

Is there a word for food that's gone 'bad', but is still edible?

Is there precedent or are there procedures for a US president refusing to concede to an electoral defeat?

Why does sound not move through a wall?

Switch Function Not working Properly

How to pass query parameters in URL in Salesforce Summer 19 Release?

GitLab account hacked and repo wiped

Speed up this NIntegrate

Constitutional limitation of criminalizing behavior in US law?

What are the requirements for a river delta to form?

Would a "Permanence" spell in 5e be overpowered?

weird pluperfect subjunctive in Eutropius

Is space itself expanding or is it just momentum from the Big Bang carrying things apart?

Why would one crossvalidate the random state number?

Make me a minimum magic sum

What is a common way to tell if an academic is "above average," or outstanding in their field? Is their h-index (Hirsh index) one of them?

Hostile Divisor Numbers

Where are the "shires" in the UK?

How do I allocate more memory to an app on Sheepshaver running Mac OS 9?

SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [closed]

How to get the max of two values in MySQL?MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nearCast from VARCHAR to INT - MySQLReference - What does this error mean in PHP?MySQL error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nearAdding multiple columns AFTER a specific column in MySQLHow to import an SQL file using the command line in MySQL?I am getting mysql error check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 4#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I have tried to put in single line neglecting white spaces but still its showing!

ACTUALL CODE THAT I WROTE IS BELOW

select first_name,last_name 
from employees 
where salary = (select min(salary) 
 from employees 
 where department_id IN (select distinct(department_id) 
 from departments);

mysql

share|improve this question

edited Mar 23 at 3:36

Alex

15.4k12039

asked Mar 23 at 3:28

rajat prakashrajat prakash

1

closed as off-topic by Alex, Bill Karwin, Nick, Strawberry, Progman Mar 23 at 10:32

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Alex, Bill Karwin, Nick, Strawberry, Progman

If this question can be reworded to fit the rules in the help center, please edit the question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You really don't like JOINs, do you! Also, note that DISTINCT is not a function
  
  – Strawberry
  Mar 23 at 7:49
  

  
  
  
  

add a comment | 

0

SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I have tried to put in single line neglecting white spaces but still its showing!

ACTUALL CODE THAT I WROTE IS BELOW

select first_name,last_name 
from employees 
where salary = (select min(salary) 
 from employees 
 where department_id IN (select distinct(department_id) 
 from departments);

mysql

share|improve this question

edited Mar 23 at 3:36

Alex

15.4k12039

asked Mar 23 at 3:28

rajat prakashrajat prakash

1

closed as off-topic by Alex, Bill Karwin, Nick, Strawberry, Progman Mar 23 at 10:32

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Alex, Bill Karwin, Nick, Strawberry, Progman

If this question can be reworded to fit the rules in the help center, please edit the question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You really don't like JOINs, do you! Also, note that DISTINCT is not a function
  
  – Strawberry
  Mar 23 at 7:49
  

  
  
  
  

add a comment | 

SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I have tried to put in single line neglecting white spaces but still its showing!

ACTUALL CODE THAT I WROTE IS BELOW

select first_name,last_name 
from employees 
where salary = (select min(salary) 
 from employees 
 where department_id IN (select distinct(department_id) 
 from departments);

mysql

share|improve this question

edited Mar 23 at 3:36

Alex

15.4k12039

asked Mar 23 at 3:28

rajat prakashrajat prakash

1

select first_name,last_name 
from employees 
where salary = (select min(salary) 
 from employees 
 where department_id IN (select distinct(department_id) 
 from departments);

share|improve this question

edited Mar 23 at 3:36

Alex

15.4k12039

asked Mar 23 at 3:28

rajat prakashrajat prakash

1

share|improve this question

edited Mar 23 at 3:36

Alex

15.4k12039

asked Mar 23 at 3:28

rajat prakashrajat prakash

1

edited Mar 23 at 3:36

Alex

15.4k12039

edited Mar 23 at 3:36

Alex

15.4k12039

asked Mar 23 at 3:28

rajat prakashrajat prakash

1

asked Mar 23 at 3:28

rajat prakashrajat prakash

1

1 Answer
1

active

oldest

votes

1

Add one more closing brace at end

select first_name
 , last_name 
 from employees
 where salary = 
 (select min(salary) 
 from employees 
 where department_id IN (select distinct(department_id) from departments)) ;

share|improve this answer

edited Mar 23 at 7:48

Strawberry

26.9k83250

answered Mar 23 at 3:35

GiriGiri

273

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  When the answer is "you are missing a closing brace", the accepted practice is that there is no need to answer. Just leave a comment under the question and flag/vote to close as Off-topic: Typo. This page will be quickly scrubbed from the site (as will any upvote points you receive) because this question has no value to other users. See: Should one advise on off topic questions?
  
  – Nick
  Mar 23 at 4:32
  

  
  
  
  

add a comment | 

1

Add one more closing brace at end

select first_name
 , last_name 
 from employees
 where salary = 
 (select min(salary) 
 from employees 
 where department_id IN (select distinct(department_id) from departments)) ;

share|improve this answer

edited Mar 23 at 7:48

Strawberry

26.9k83250

answered Mar 23 at 3:35

GiriGiri

273

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  When the answer is "you are missing a closing brace", the accepted practice is that there is no need to answer. Just leave a comment under the question and flag/vote to close as Off-topic: Typo. This page will be quickly scrubbed from the site (as will any upvote points you receive) because this question has no value to other users. See: Should one advise on off topic questions?
  
  – Nick
  Mar 23 at 4:32
  

  
  
  
  

add a comment | 

1

Add one more closing brace at end

select first_name
 , last_name 
 from employees
 where salary = 
 (select min(salary) 
 from employees 
 where department_id IN (select distinct(department_id) from departments)) ;

share|improve this answer

edited Mar 23 at 7:48

Strawberry

26.9k83250

answered Mar 23 at 3:35

GiriGiri

273

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  When the answer is "you are missing a closing brace", the accepted practice is that there is no need to answer. Just leave a comment under the question and flag/vote to close as Off-topic: Typo. This page will be quickly scrubbed from the site (as will any upvote points you receive) because this question has no value to other users. See: Should one advise on off topic questions?
  
  – Nick
  Mar 23 at 4:32
  

  
  
  
  

add a comment | 

Add one more closing brace at end

select first_name
 , last_name 
 from employees
 where salary = 
 (select min(salary) 
 from employees 
 where department_id IN (select distinct(department_id) from departments)) ;

share|improve this answer

edited Mar 23 at 7:48

Strawberry

26.9k83250

answered Mar 23 at 3:35

GiriGiri

273

select first_name
 , last_name 
 from employees
 where salary = 
 (select min(salary) 
 from employees 
 where department_id IN (select distinct(department_id) from departments)) ;

share|improve this answer

edited Mar 23 at 7:48

Strawberry

26.9k83250

answered Mar 23 at 3:35

GiriGiri

273

edited Mar 23 at 7:48

Strawberry

26.9k83250

edited Mar 23 at 7:48

Strawberry

26.9k83250

answered Mar 23 at 3:35

GiriGiri

273

answered Mar 23 at 3:35

GiriGiri

273