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
- 3503 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 to trouble shoot if unable to connect SQL Server
What is the optimization being performed in oracle and SQL Server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
Why would you use sql agent?
What is query optimizer in sql server?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Define outer join in sql server joins?
What is a trigger and types of a trigger?
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
What authentication modes does sql server support?
Do you know what is normalization of database? What are its benefits?
What stored by the msdb?
-
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)
