By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,271 Members | 1,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,271 IT Pros & Developers. It's quick & easy.

Joined date

kiss07
P: 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
Share this Question
Share on Google+
4 Replies

debasisdas
Expert 5K+
P: 8,127
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
Expert 5K+
P: 8,127
Write in clear concise language using correct grammar and spelling
May 3 '07 #3

kiss07
P: 99
Dear friend,

I don't know what is problem .I submit clear case myside.
May 3 '07 #4

kiss07
P: 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.