561 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
As well as a series of 30 or so videos showing you how to program in SQL (from writing simple queries through to creating complicated stored procedures), we've also got videos on how to install and use SQL Server 2016.
|Selecting data in SQL||12|
|Advanced SQL (programming)||18|
|SQL Server 2016||9|
|SQL Server 2017||3|
Just click on any of the links above to see a complete listing for that category of SQL videos.
|When:||05 Sep 21 at 01:47|
Please I have been following your sql tutorials on YouTube and I appreciate your unique teaching program.
I have a problem and hope you can assist me. Here is my problem;
I have an Event table with these columns;
EventID EventDate W1 W2 W3 W4 W5 M1 M2 M3 M4 M5
1 20-1-1962 1 2 3 4 5 6 7 8 9 10
2 21-1-1962 3 8 31 40 21 42 25 1 11 5
3 22-1-1962 14 21 41 56 1 42 32 31 5 67
Problem: 1. Where W1=1 in an Event, Select the next one event and previous one event. Event to select could be anything 2,3,4 or any specified envent
that is if a column in an event contain a specified number, select the previous event and the next specified event.
Problem 2. How do I iterate through the entire database and select these events and have it stored as a procedure?
|When:||06 Sep 21 at 07:06|
You can use the Lag and Lead methods to do this
I hope it helps!
25 Aytoun Street