470,647 Members | 1,188 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Joined date

kiss07
99
Hi friends,

I want to select records those are joined date is 23/03/07 in a table.
This is simple query .i need answer ..I have an date function error in myside.

and another query.

In a table there are i want to select those employees are taken maximum
leave in a month in department wise.

Expecting outout:

Department employee days

Keynote arun 3
shakil 3

performix nisha 4
shaju 4


Air defence ramesh 2


i need a standard query..Pls help..(note: keynote ,perfromix,airdefence are department)

Arun..
May 3 '07 #1
4 1138
debasisdas
8,127 Expert 4TB
for your first query use
Expand|Select|Wrap|Line Numbers
  1. select * from table_name where join_date ='23-mar-07'
  2.  
it is simple
if your question is different please post here
May 3 '07 #2
debasisdas
8,127 Expert 4TB
Write in clear concise language using correct grammar and spelling
May 3 '07 #3
kiss07
99
Dear friend,

I don't know what is problem .I submit clear case myside.
May 3 '07 #4
kiss07
99
In a table there are i want to select those employees are taken maximum
leave in a month in department wise.

Expecting outout:

Department employee days

Keynote arun 3
shakil 3

performix nisha 4
shaju 4


Air defence ramesh 2


i need a standard query..Pls help..(note: keynote ,performix,airdefence are department)
May 3 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Metal Dave | last post: by
1 post views Thread by Ike | last post: by
5 posts views Thread by zMisc | last post: by
reply views Thread by Rhamphoryncus | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.