Joined date

[kiss07]

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

[debasisdas]

for your first query use

select * from table_name where join_date ='23-mar-07'
 

it is simple
if your question is different please post here

[debasisdas]

Write in clear concise language using correct grammar and spelling

[kiss07]

Dear friend,

I don't know what is problem .I submit clear case myside.

[kiss07]

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)