Sign Up Login


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

Write a SQL Query to find first Week Day of month?

Question Posted / saravakumar

Answers were Sorted based on User's Feedback



Write a SQL Query to find first Week Day of month?..

Answer / saravakumar

SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) +
1, GETDATE())) AS FirstDay

Is This Answer Correct ?    31 Yes 2 No

Write a SQL Query to find first Week Day of month?..

Answer / vijay

SELECT DATENAME(dw, DATEADD(dd, – DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How to defragment indexes with alter index ... Reorganize?

0 Answers  

What is an index in sql?

0 Answers  

How to resolve the orphan use problem? : sql server security

0 Answers  

What is an indexed view?

0 Answers  

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

Explain what are the different index configurations a table can have?

0 Answers  

Explain the different types of joins?

0 Answers  

Differentiate between mongodb vs. Sql server?

0 Answers  

What is a mutating table error and how can you get around it?

0 Answers  

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

For more SQL Server Interview Questions Click Here
Categories