Interested to Buy Any Domain ? << Click Here >> for more details...
please bar with my english
i having a database called tblhallreservation in which
res_date is date field
has to select all the fields in table deponding on month
either has to display all details for the month jan or feb
and so on
- 1 Answers
- 3455 Views
- I also Faced
- E-Mail Answers
Answer / kiran bala rath
select datename(mm,res_date),* from Tablename order by
convert(int,right(left(convert(varchar,res_date,105),5),2))
asc
| Is This Answer Correct ? | 0 Yes | 0 No |
How extra digits are handled with numeric data type literals?
Explain left outer join and right outer join?
How to remove duplicate rows from table?
What are information schema views?
What is sleeping status in sql server?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Do you know what is xpath?
Explain the properties of sub-query in sql server?
What does the on delete cascade option do?
What is the bookmark lookup and rid lookup?
What is the difference between indexing and hashing?
What is difference between restoration and recovery in SQLServer?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
