Don't Understand
Find the errors in this SQL code:
SELECT first_name, last_name salary FROM employees ORDER BY department_id WHERE hire_date > 01/06/1990;
Thank you for Your Help
View Answers
October 19, 2010 at 5:06 AM
Hi,
The ORDER BY class should be after the where condition.
The correct sql is:
SELECT first_name, last_name salary FROM employees WHERE hire_date > 01/06/1990 ORDER BY department_id;
Thanks Deepak
October 19, 2010 at 5:06 AM
SELECT firstname, lastname salary FROM employees WHERE hiredate > 01/06/1990 ORDER BY departmentid
October 19, 2010 at 5:14 AM
Hi,
Another error is sql:
You should specify the date in double quotes and it should be in YYYY-MM-DD format. Here is the corrected sql:
SELECT first_name, last_name salary FROM employees WHERE hire_date > '1990-06-01' ORDER BY department_id;
Thanks
Related Tutorials/Questions & Answers:
Don't Understand
Don't Understand Find the errors in this SQL code: SELECT first_name, last_name salary FROM employees ORDER BY department_id WHERE hire_date > 01/06/1990; Thank you for Your HelpADS
Don't Understand Find the errors in this SQL code: SELECT first_name, last_name salary FROM employees ORDER BY department_id WHERE hire_date > 01/06/1990; Thank you for Your HelpADS
title and keywords don't refresh in webpage - JSP-Servlet
title and keywords don't refresh in webpage Hi, I changed the title and keywords on my main jsp page that is the entry point into my web application. However when I restart server and do view source I still see the old title
title and keywords don't refresh in webpage Hi, I changed the title and keywords on my main jsp page that is the entry point into my web application. However when I restart server and do view source I still see the old title
Advertisements
Unable to understand Struts - Struts
Unable to understand Struts I am studying in GNIIT from NIIT. Here in 4th sem we have stuts also but I am not able to understand it. I've made an application.That application is of book entry. I have made the application
Unable to understand Struts I am studying in GNIIT from NIIT. Here in 4th sem we have stuts also but I am not able to understand it. I've made an application.That application is of book entry. I have made the application
What do you understand by Virtual Hosting?
What do you understand by Virtual Hosting? What do you understand by Virtual Hosting? I am trying to find the hosting server provider but don't know about the hosting terms. Just explain me about Virtual Hosting. Thanks
What do you understand by Virtual Hosting? What do you understand by Virtual Hosting? I am trying to find the hosting server provider but don't know about the hosting terms. Just explain me about Virtual Hosting. Thanks
What do you understand by JPA?
What do you understand by JPA? What is JPA and how it can be integrated? Thanks Hi, Check at JPA 2.1 Tutorial. Thanks
What do you understand by JPA? What is JPA and how it can be integrated? Thanks Hi, Check at JPA 2.1 Tutorial. Thanks
Please help me understand this query
Please help me understand this query Hi, Could someone please help me understand the following query. Im finding difficulty relating it :-( Pls Help! select * from cbpartner where CBPartner.IsSummary='N' and salesrep_id
Please help me understand this query Hi, Could someone please help me understand the following query. Im finding difficulty relating it :-( Pls Help! select * from cbpartner where CBPartner.IsSummary='N' and salesrep_id
I don't found in Tomcat 7.0 's bin folder..
I don't found in Tomcat 7.0 's bin folder.. While making servlet using tomcat 7.0, i don't find startup.bat file in bin folder. My servlet..... but when i type http://localhost:8080/ on browser then i get tomcat page. I don't
I don't found in Tomcat 7.0 's bin folder.. While making servlet using tomcat 7.0, i don't find startup.bat file in bin folder. My servlet..... but when i type http://localhost:8080/ on browser then i get tomcat page. I don't
What do you understand by private, protected and public?
What do you understand by private, protected and public? Hi, What do you understand by private, protected and public? thanks
What do you understand by private, protected and public? Hi, What do you understand by private, protected and public? thanks
I don't know how to use counter variable in this Qustion ....:(
I don't know how to use counter variable in this Qustion ....:( Declare and initialize value of array in int type. read and assgin all the mark to every students by using counter variable, k. output should be like
I don't know how to use counter variable in this Qustion ....:( Declare and initialize value of array in int type. read and assgin all the mark to every students by using counter variable, k. output should be like
What do you understand by Kafka broker
What do you understand by Kafka broker Hi, What do you understand by Kafka broker? Thanks Hi, Kafka is designed in mind with clustring and there can be many sever in Kafka cluster. The term Kafka Broker is used
What do you understand by Kafka broker Hi, What do you understand by Kafka broker? Thanks Hi, Kafka is designed in mind with clustring and there can be many sever in Kafka cluster. The term Kafka Broker is used
What do you understand by Domain Parking?
What do you understand by Domain Parking? What is the domain parking concept in the web hosting? How to part a domain? What is Domain Parking? Which hosting companies are providing the domain parking services? Thanks
What do you understand by Domain Parking? What is the domain parking concept in the web hosting? How to part a domain? What is Domain Parking? Which hosting companies are providing the domain parking services? Thanks
What do you understand by Hibernate in Java?
What do you understand by Hibernate in Java? Hey, do you know about Hibernate in Java? I have to learn it for my next project. What is the best and probably most easiest way to learn this Hibernate stuff? How it is beneficial
What do you understand by Hibernate in Java? Hey, do you know about Hibernate in Java? I have to learn it for my next project. What is the best and probably most easiest way to learn this Hibernate stuff? How it is beneficial
MY Sql Query Error - Not able to Understand the issue
MY Sql Query Error - Not able to Understand the issue I am new at MYSQL,I wrote simple query as follow: CREATE Table tblFeedBack ( FeedBackID INT AUTOIncremeNT, UserID INT, InsertedTS TIMESTAMP , FeedBackValue VARCHAR(100
MY Sql Query Error - Not able to Understand the issue I am new at MYSQL,I wrote simple query as follow: CREATE Table tblFeedBack ( FeedBackID INT AUTOIncremeNT, UserID INT, InsertedTS TIMESTAMP , FeedBackValue VARCHAR(100
tell me i don't know about cms and history - Java Interview Questions
tell me i don't know about cms and history what is cms,when can it is used ,what are the advantages and what are the more information about CMS
tell me i don't know about cms and history what is cms,when can it is used ,what are the advantages and what are the more information about CMS
What do you understand by the are PHP, ASP and Perl languages?
What do you understand by the are PHP, ASP and Perl languages? Tell me about PHP, ASP and Perl languages as web hosting guys are asking about these technologies while selecting the hosting package. Thanks Hi
What do you understand by the are PHP, ASP and Perl languages? Tell me about PHP, ASP and Perl languages as web hosting guys are asking about these technologies while selecting the hosting package. Thanks Hi
what do you understand by big data and what are its basic components
what do you understand by big data and what are its basic components Hi, I have decided to learn Big Data and finding tutorials of Big Data. What is big data and what are its basic components? Thanks Hi, Big Data
what do you understand by big data and what are its basic components Hi, I have decided to learn Big Data and finding tutorials of Big Data. What is big data and what are its basic components? Thanks Hi, Big Data
Manage end-user state and understand performance tradeoffs of using HTTP sessions
Manage end-user state and understand performance tradeoffs of using HTTP sessions Prev Chapter 2. ...; Manage end-user state and understand performance tradeoffs of using HTTP
Manage end-user state and understand performance tradeoffs of using HTTP sessions Prev Chapter 2. ...; Manage end-user state and understand performance tradeoffs of using HTTP
MySQL Access Control
- and they don't usually look deeper to understand how it handles access privileges
- and they don't usually look deeper to understand how it handles access privileges
Class names don't identify a class - Java Tutorials
Class names don't identify a class In JDK 1.2 the Sum Microsystems have added a new feature that allows you to identify a class not only by its name but also by its context for which it was loaded. For this you need to set
Class names don't identify a class In JDK 1.2 the Sum Microsystems have added a new feature that allows you to identify a class not only by its name but also by its context for which it was loaded. For this you need to set
What do you understand by Big Data?
What do you understand by Big Data? Introduction The term Big Data was introduced to define data sets that were ever increasing in their Volume, Variety and Velocity, also known as the 3Vs. Such data sets were tough to be processed
What do you understand by Big Data? Introduction The term Big Data was introduced to define data sets that were ever increasing in their Volume, Variety and Velocity, also known as the 3Vs. Such data sets were tough to be processed
Compressing the file into GZIP format.
Compressing the file into GZIP format. This example will help to understand the concepts of GZIP. GZIP compresses the actual size of data files. It is a file
Compressing the file into GZIP format. This example will help to understand the concepts of GZIP. GZIP compresses the actual size of data files. It is a file
Java Vs Script
although posses same name but don't have any common properties. Both the language... Understand Java and Script language in more detail Java Java is completely... to understand. The Java have a Java Virtual Machine(JVM) that allows java to run on any
although posses same name but don't have any common properties. Both the language... Understand Java and Script language in more detail Java Java is completely... to understand. The Java have a Java Virtual Machine(JVM) that allows java to run on any
Ajax Examples
Ajax Examples Displaying Time: This example is simple one to understand Ajax with JSP. The objective of the example is to display the current date
Ajax Examples Displaying Time: This example is simple one to understand Ajax with JSP. The objective of the example is to display the current date
Java Comparison
Java Comparison Java Vs Script The Java and Java Script are completely different from each other although posses same name but don't have
Java Comparison Java Vs Script The Java and Java Script are completely different from each other although posses same name but don't have
Common Interview Questions Page - 7
performance truly reflect your talents? Answer: Don't say that you deserved better... is to check your commitment. So if you are keen to join the new organization don't... the interviewer clear that you are committed to your work and you better understand
performance truly reflect your talents? Answer: Don't say that you deserved better... is to check your commitment. So if you are keen to join the new organization don't... the interviewer clear that you are committed to your work and you better understand
Duplicated Session Variables
Duplicated Session Variables We don't have any need to create a new session variable because it has been created by the JSP container for you
Duplicated Session Variables We don't have any need to create a new session variable because it has been created by the JSP container for you
PHP Variables from URL
PHP Variables from URL Are you facing problem passing PHP variable from URL? Don't worry, it is quite easy to learn and implement into your project. Remember one thing if you are passing unnecessary information in the URL is fine
PHP Variables from URL Are you facing problem passing PHP variable from URL? Don't worry, it is quite easy to learn and implement into your project. Remember one thing if you are passing unnecessary information in the URL is fine
How does Social Media Marketing Work
How does Social Media Marketing Work In this section we will understand the working of Social Media Marketing and see "How Social Media Marketing actually Works"? As you all know Internet users visits the Social Networking
How does Social Media Marketing Work In this section we will understand the working of Social Media Marketing and see "How Social Media Marketing actually Works"? As you all know Internet users visits the Social Networking
How Spring MVC Module Works
understand the sequences of the events happens when a request is received
understand the sequences of the events happens when a request is received
Why XML?, Why XML is used for?
Why XML? In this section we will understand the importance of XML and see Why XML is so important these days. We will also see the different usages of XML. The XML is very simple language that allows the developers to store
Why XML? In this section we will understand the importance of XML and see Why XML is so important these days. We will also see the different usages of XML. The XML is very simple language that allows the developers to store
JSF Life Cycle
JSF Life Cycle In this we will understand the life cycle of JSF application. Life cycle of a JSF web application starts when user makes a request. On submission
JSF Life Cycle In this we will understand the life cycle of JSF application. Life cycle of a JSF web application starts when user makes a request. On submission
XML Interviews Question page19
namespaces? I don't know the answer to this question, but the likely reason...;Address type="home"> To understand why this is true, remember
namespaces? I don't know the answer to this question, but the likely reason...;Address type="home"> To understand why this is true, remember
Relo - Relationship based Exploration
Relo - Relationship based Exploration Relo helps developers explore and understand large codebases. Developers often face code that is hard to understand with over
Relo - Relationship based Exploration Relo helps developers explore and understand large codebases. Developers often face code that is hard to understand with over
Applet versus Application
while applications are larger programs. Applets don't have the main method while... programming purpose while the applications don't have such type of criteria. Applet... of internet. It doesn't mean that the java applications don't have the place. Both
while applications are larger programs. Applets don't have the main method while... programming purpose while the applications don't have such type of criteria. Applet... of internet. It doesn't mean that the java applications don't have the place. Both
Analysis tool - SourceGlider for Eclipse
and harder to understand. SourceGlider helps to uncover the real types... aspects of the program code, understand the meanings of lots of classes, methods and variables. Now SourceGlider will do it for you! You don't need to execute
and harder to understand. SourceGlider helps to uncover the real types... aspects of the program code, understand the meanings of lots of classes, methods and variables. Now SourceGlider will do it for you! You don't need to execute
Set Frame Inside HTML
Set Frame Inside HTML The Tutorial helps you to understand how to set... page. Understand with ExampleADS_TO_REPLACE_1 The Example create a HTML page
Set Frame Inside HTML The Tutorial helps you to understand how to set... page. Understand with ExampleADS_TO_REPLACE_1 The Example create a HTML page
While Loop Statement in java 7
While Loop Statement in java 7 This tutorial, helps you to understand the concept of while loop in java 7. While Loop Statements : While loop... repeat the task certain number of times. It is more easier to understand
While Loop Statement in java 7 This tutorial, helps you to understand the concept of while loop in java 7. While Loop Statements : While loop... repeat the task certain number of times. It is more easier to understand
Facelet remove Tag
Facelet remove Tag This tag is used to remove content within this tag from a facelet at compile time. This tag don't have any
Facelet remove Tag This tag is used to remove content within this tag from a facelet at compile time. This tag don't have any
Session Using URLRewriting
Session Using URLRewriting URLRewriting can be used in place where we don't want to use cookies. It is used to maintain the session. Whenever
Session Using URLRewriting URLRewriting can be used in place where we don't want to use cookies. It is used to maintain the session. Whenever
Difficult Interview Questions Page -9
, "I don't enjoy admonishing people, so I try to begin with something... illustrate that though you don't enjoy unpleasant tasks but that you can... trends that illustrate how well you understand your industry. If you
, "I don't enjoy admonishing people, so I try to begin with something... illustrate that though you don't enjoy unpleasant tasks but that you can... trends that illustrate how well you understand your industry. If you
Struts Video Tutorials
on Struts framework. These video tutorials is easy to learn and understand. You
on Struts framework. These video tutorials is easy to learn and understand. You
SQL for Beginner
want to learn and understand SQL in easy steps. The Tutorial provides you a illustrative examples, which is easy to understand and learn using on-line SQL
want to learn and understand SQL in easy steps. The Tutorial provides you a illustrative examples, which is easy to understand and learn using on-line SQL
Difficult Interview Questions Page -2
a meaningful contribution to our firm? Answer: Don't be imaginary, and never say... understand the priorities of the work and manage my time according to importance... to this question. But be careful to answer this question and don't focus too much
a meaningful contribution to our firm? Answer: Don't be imaginary, and never say... understand the priorities of the work and manage my time according to importance... to this question. But be careful to answer this question and don't focus too much
What is Constructor Overloading in Java?
will learn about the construction overloading in Java and understand this concept... as we declare methods, except that the constructor don't have any return type...; int l, b; float p, q;
will learn about the construction overloading in Java and understand this concept... as we declare methods, except that the constructor don't have any return type...; int l, b; float p, q;
Ads