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
- 3533 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 |
What is difference between delete & truncate commands?
what purpose does OPENXML clause have in sql server stored procedure?
What is the primary use of the model database?
query processing
What are the main control-of-flow T-SQL constructs?
What is the difference between functions and scalar functions?
What is the difference between functions and stored procedures?
explain how to create a new schema in a database? : Sql server database administration
Explain the difference between delete,drop and truncate in SQL Server?
How do you Implement SSIS Packages in your Project?
What is the architecture of ms sql reporting service?
Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.
-
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)
