Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL Don't Understand
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Ann Monroe
Don't Understand
3 Answer(s)      4 years and 2 months ago
Posted in : SQL


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


Advertisement
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 Help   Hi
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
Advertisements
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
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
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
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
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
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
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
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
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
MySQL Access Control
- 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
Hibernate hbm.xml
This tutorial is helpful to understand about hbm.xml
ORM Hibernate
In this tutorial you will understand the concept of ORM
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
MyEclipse Hibernate Tutorial
This tutorial is helpful to understand how hibernate work in MyEclipse
Java Vs Script
although posses same name but don't have any common properties. Both the language... we can change the properties and method of the object. Let Us Understand... is similar to C++, but the syntax is simple and easy to understand. The Java have
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
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
Social Media is Easy
media campaign yourself so that you can understand that social media is easy
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
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
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
Java EE or Java
Java correctly. So, let's first understand about different distribution
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
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
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
How Spring MVC Module Works
of Spring MVC: Let's understand the sequences of the events
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
Advertisements
 

 

 

DMCA.com