1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

write an SQL query to list the employees who joined in the month of January?

Question Posted / venkatesh


write an SQL query to list the employees who joined in the month of January?..

Answer / Neeraj Chauhan

{"sql_query": "SELECT * FROM EMPLOYEES WHERE JOINED_DATE BETWEEN '01-01-YYYY' AND '31-12-YYYY'". Replace YYYY with the year you are querying for.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain how does the report manager work in ssrs?

1 Answers  

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

1 01 101 01010

1 Answers  

What does normalization do to data?

1 Answers  

Does partitioning improve performance?

1 Answers  

how to get the automatic backup of the database in the sql server

4 Answers  

Is foreign key a primary key?

1 Answers  

List down some advantages of sql stored procedure?

1 Answers  

explain databases and sql server databases architecture? : Sql server database administration

1 Answers  

How to integrate the ssrs reports in application?

1 Answers  

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1 Answers  

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

For more SQL Server Interview Questions Click Here
Categories