Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find the employees from EMP table those who
have joined in Monday. (there is a column as hiredate which is
a date column i.e values are like 03-DEC-81)
- 5 Answers
- 10401 Views
- I also Faced
- E-Mail Answers
Answer Posted / masuduz zaman
SELECT * FROM EMP
WHERE (DATEPART(dw, HIREDATE) + @@DATEFIRST) % 7 = 2
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the requirement of self-join?
Can you inner join the same table?
What makes a good primary key?
What are some predefined exceptions in pl/sql?
What types of commands can be executed in sql*plus?
What are character functions in sql?
What is pl/sql table? Why is it used?
How do you declare a user-defined exception?
Enlist the advantages of sql.
Can we have two clustered index on a table?
What is a unique constraint?
what is bdb (berkeleydb)? : Sql dba
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Explain the significance of the & and && operators in pl sql.
Which table is left in left join?
