Don't Understand

Home Answers Viewqa SQL Don't Understand

QuestionAsk Questions?

Ann Monroe

Don't Understand
3 Answer(s) 2 years and 7 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

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

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

Absolute Layout
ignorant. When I see it I know the programmer is doing it because the don't understand layouts. Copyleft 2003 Fred Swartz MIT License

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

Difficult to understand - Hibernate

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

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 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 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 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

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

MySQL Access Control
- and they don't usually look deeper to understand how it handles access privileges

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

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

Social Media is Easy
media campaign yourself so that you can understand that social media is easy

JLabel text alignment
Java: JLabel text alignment What tabs don't work The basic problem is that there is no fixed definition for tab, which more or less means move... amount. Why spaces don't work And it's also impossible to align things using

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

Database books Page20
of us who don't have time to wade through the hundreds of pages of documentation, but instead wish to quickly understand how to create simple XML output and input

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

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

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

Hibernate hbm.xml
This tutorial is helpful to understand about hbm.xml

ORM Hibernate
In this tutorial you will understand the concept of ORM

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

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

Common Interview Questions Page - 10
, then it is obvious that you will face this question. However, don't take... of days. The manager can very well understand you’re responsibilities

Java Notes: Generics
to understand how and why they are used. Basic problem -- restricted... Collections data structures. Don't use them for statics. Java's type erasure

Uploading Employee Profile with image
to understand how you can upload multiple files by using the Jsp. We should avoid... problem while reading or parsing the request. Don't worry this is not going

MyEclipse Hibernate Tutorial
This tutorial is helpful to understand how hibernate work in MyEclipse

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

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

Generating Random Number
understand and use the code to generate random numbers in your java application... number in the range which can be specified. If you don't mention the range value

doubt in struts - Struts
doubt in struts i don't understand the concept on Resource bundle in struts can u please help me out

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

Benefits of Cloud Computing

Tomahawk inputSecret tag
with type password. You can not understand the value of the component just seeing... are not able to understand what have been written in the box. This tag has... reference component by id in the javascript. If we don't use this attribute

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

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

Learn Online Java Training
high and for that, comprehensive and easy to understand course content... don't have to go through the unnecessary expenditures of traveling, buying

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

VoIP Solution
business. We also understand that selecting VoIP solutions can be challenging... don't want to mess with, especially if you're toting a cell phone

Java EE or Java
Java correctly. So, let's first understand about different distribution

Photoshop eye color brown to blue

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

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

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

JSP Scriptlets Example

What is XHTML?

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics