Tech
Forums
Jobs
Books
Events
Live
Learn
More
Training
Interviews
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
8
Reply
How to use UNION ALL in SQL query.
Bineesh VP
Dec 19 2016 12:20 AM
298
Reply
Sir,
I need your help in below query.
I need to use order by and UNION ALL in query given below in order to get 1000 rows in a single execution.
select strCustomerID, strDate, strUser, strAction from
( select top 1 *
from tblFollowupdetail where strCustomerID='AB7356'
and strDate between convert(datetime,'01/12/2016',103)
and convert(datetime,'15/12/2016',103)
order by strDate desc ) last
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
8
)
Next Recommended Forum
join three table
insert query with 10 records at at a time