Dear Sir, With great honor and due respect I m praying for a long breath for your self. such type of man like you would be gurdian for the youngsters and for the tech guys
@anushreegupta1500
3 жыл бұрын
When he showed today's date, I was like I am 7 years behind. I should have learnt this 7 years ago.
@mandarnandre7387
2 жыл бұрын
For me it is 8 yrs LOL
@TrendSplashTV
3 ай бұрын
@@mandarnandre7387 For me it is 10 yrs LOL
@vanshikakaushik3887
21 күн бұрын
@@mandarnandre7387 For me it's 10 yrs *_*
@pinkilihitkar8093
3 жыл бұрын
Very Helpful.. I follow you whenever I stuck somewhere in sql queries...and everytime it works for me...
@priyankatripathi562
7 жыл бұрын
you are genius..I almost get all the answers in your video. Highly appreciate your hard work.Best Regards
@rock5522
4 жыл бұрын
Your videos are the best and simple which is available in internet and that too for free !! Appreciate your hard work and efforts.. thanks alot !
@BibekerKathghora
2 жыл бұрын
Feeling lucky to be digit changer on "Like" 👍, really helpful videos - Best wishes forever
@devexpost8508
7 жыл бұрын
Kudvenkat, It seems to me that your solution as shown is incorrect for the question of "which employees were hired in the last 3 months". I believe your WHERE clause should look for a DATEDIFF between *0 and 2* or *0 and 3* (depending on how you define "last 3 months"), but NOT *1 and 3*. You are missing Hastings and Anderson I believe. Thanks much.
@krishnanaasevagar2345
3 жыл бұрын
I too got the same doubt
@uppalasandhya6131
7 жыл бұрын
Hi Venkat Garu, One of the interview question that i have faced with that is Can we insert a stored procedure inside another stored procedure and How? could please make a video on this
@babzo1
10 жыл бұрын
Thanks Venkat,simply the best
@JokerGotNoRules
9 жыл бұрын
You have made my life easy..I am a student doing placement and I was asked that on Monday there is a REPORT that i need to create and the date function it required was exactly this 1 :D i know all other apps to design and upload it report manager but this was a problem for me..and MOST ANOYINGLY today i run Anti-virus on my external HDD and it deleted my GUIDE ..kill me lol
@pankajmogra457
6 жыл бұрын
we can use small query as well in CTE say " select * from emp e1 where rowid > (select min(rowid) from emp e2 where e2.empno=e1.empno);"
@learningislife2934
4 жыл бұрын
I.am big fan sir 😎 2019
@Indian_working_mom
4 жыл бұрын
excellent tutorial sir thank you so much
@yasminkhanam9464
8 жыл бұрын
Hi sir, Frequently asked question in interview is .. what is the maxium size of DB that you worked upon .. how shall we answer this and also how do you optimize your query ... Requesting you to please add these two best answers. Thank you. These answers are very beneficial.. Thank you for explaining step by step .
@Csharp-video-tutorialsBlogspot
8 жыл бұрын
+yasmin khanam Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. Sure, I will record and upload videos answering your questions very soon. Thank you very much for your patience. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you kzitem.infoplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. kzitem.info/news/bejne/2m1uloGtoYtoY6g If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzitem.info If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat
@draxikito
9 жыл бұрын
Venkat is the MAN!
@raviras4961
10 жыл бұрын
hello sir your videos are really useful for us and are easy to understand. can you please upload video series on 3 tier arch. as interviewer asks it many times.
@sanjeevsharma9661
10 жыл бұрын
your video always best. please if possible upload SSIS Video
@rohitshetty7698
9 жыл бұрын
Thanks a lot Sir,You are awesome
@rohittaralekar5400
6 жыл бұрын
Thanx for videos, always helpful, I have query, Table Stock Name Value Date ABC 45 15-JAN-13 ABC 50 14-JAN-13 ABC 23 13-JAN-13 I want output as : ABC 45/50 i.e. today's value/yesterday's value
@durgeshsingh4811
6 жыл бұрын
Hello sir, these videos is very usefull and I want please make interview videos on MVC. please please sir
@arjunv8102
8 жыл бұрын
where you save stored funtions exceptions in sql server
@vassug7226
9 жыл бұрын
how to get the rows from 50 to 100 from a table with 200 rows, without using ROW_NUMBER. The table does not have an id column.
@aswathybaby2857
5 жыл бұрын
Hi sir, Can you please answer me the sql query to find persons born on same day? Thanks!
@jegathaambika4327
2 ай бұрын
If a interviewer asked why ur using cte. Concept what should we tel
@Gops77
2 жыл бұрын
Which function can we use to achieve the same results in Oracle SQL Developer?
@shivanigangwar4959
3 жыл бұрын
what is the query if i want to Select Last 10 Year and fetch the total sum an Employee Earns for the last 10 Year??
@jerseyblue888
9 жыл бұрын
You are the Best!
@shalinikeshri5652
2 жыл бұрын
hello sir, How can we find of list of employees who worked for more than 12 hours in each day for four consecutive day?
@dudewheresmycar3618
5 жыл бұрын
I have the latest sale date. I need all sales made prior to that date, however all prior sales(if any) must have been made in the last 12 months prior to the latest sales date. Please Help
@mrsbenedictcumberbatch9565
6 жыл бұрын
i mean, were u an in-flight announcer, u talk so well
@MeerVideos
3 жыл бұрын
:D
@harisravya9205
4 жыл бұрын
Hi kudvenkat I need your help in resolving below query i have 100 files which receive daily ...and i have cutoff time for each file arrival of file arrives in respective folder for that file an additional column updates output as 0 else 1 Out of 100 files i have 20 files ...on Friday these files will arrive on Monday but not Saturday ...could you please how to write a query which get Friday dates between range of dates ...if the date is Friday than it should not pop as 1 ( file not arrived by Saturday cutoff time ) i should check monday cutoff time Can you pleas help on this . Many thanks
@rutavdharek9144
7 жыл бұрын
Hello Venkat, these videos are very helpful. it will great, if you would share your blog URL from where we can refer SQL script. Thank you, Rutav
@KrishnaMohan-qi2vs
Жыл бұрын
Display the number of employees joined in each month in EMP table how can we write query
@yussiffiankomaverick193
2 жыл бұрын
Great video
@Sayon____bhattacharjee
4 жыл бұрын
Sir, Why not working in Oracle SQL Developer? Error ORA-00923: FROM keyword not found where expected 00923. 00000 - "FROM keyword not found where expected"
@harshsaxena05
3 жыл бұрын
what if we want to delete duplicate by duplicate names?
@rajkalshetty3857
7 жыл бұрын
Thanks Sir your videos are most useful to me. Kindly share the script file for creation of database and tables.
@jitendrabisht4398
9 жыл бұрын
Simply awesome man !!!
@shubhangijagtap6524
5 ай бұрын
table is not reflecting here...pls share
@HarishBabuD
5 жыл бұрын
Hi, can you help in getting head count based on hire and termination date order by month
@ranjithk9296
3 жыл бұрын
Display all employees with how many years they have been servicing in the company?
@javidhesenov7611
2 жыл бұрын
thanks
@Indian_working_mom
4 жыл бұрын
anybody telll me datediff function is not working in oracle 10g sql it display the invalid identifier like that ,,,anybody tell me datediff is support or not for oracle 0g
@preetam051
9 жыл бұрын
I have a quick doubt here hope u will help on the query, "What if they ask about all the employees who got hired in the first half of the month". Thank you.
@MayankGupta303
5 жыл бұрын
Then you should use something like DATEDIFF(DAY, Hiredate, GETDATE()) BETWEEN 1 AND 15 ORDER BY Hiredate asc
@ManishSharma-js4br
9 жыл бұрын
HI.. How get your Blogs having the SQL script ...
@NIRMALA-ts6pf
6 жыл бұрын
How to write a query using two tables, For Ex: Display products that are sold in the current year and not in the previous year(products_name in table1 and sold_date another table2)
@Csharp-video-tutorialsBlogspot
6 жыл бұрын
Hello Nirmala, Good question. Combination of JOINS and WHERE clause can help you achieve this. If you are new to joins, please check out the following video on joins. kzitem.info/news/bejne/2I1q3peHbHh3o2k I think the WHERE clause is discussed in the following video, but not 100% sure. Please check it out. Hope this helps write the query yourself. kzitem.info/news/bejne/s2-mvqJ-gnibkm0
@stutitehri993
10 жыл бұрын
nice tutorial
@subhasaha8988
7 жыл бұрын
How to find customer who have not placed order in last 6 months
@jiturcm1
10 жыл бұрын
nice video
@harishpoojari2132
2 жыл бұрын
Sir Please post SQL query which you used to create table for this video
@bodanamsruthireddy7282
5 жыл бұрын
Only joined 2005 to 2015 list Then how to write the code
@yesubabu2880
8 жыл бұрын
why r u using function ..just date>getdate-60:
@ramchandrathakkar2022
10 жыл бұрын
Gread Video.. Thanks.
@MOHDNADEEM-vg8hm
4 жыл бұрын
How to fetch previous month data from database in php?
@saagarsoni3
10 жыл бұрын
thnx a lot sir
@elenaperez691
3 жыл бұрын
Hi this was so very helpful. I was wondering if you can help with my query? I work in health care and I have identified the patients I am looking for based on CPT and ICD10 codes. But now I need to see if they have had 5 visits in 10 weeks. I would greatly appreciate yours or anyone else reading this message who would know how to filter for those patients. Thank you in advance.
@shivanandpulakanti3459
2 жыл бұрын
calculate visits at the patient level. and then filter accordingly
@jiaozibaozi3209
4 жыл бұрын
can use dateadd too
@adilkevin6220
7 жыл бұрын
also in file control how can I rename a file name in edit mode of gridview kindly release it
@rohitpatil1993
7 жыл бұрын
hello sir kindly share the Script of query for practice. That would be a great help
@ritikasri7073
4 жыл бұрын
Plzzz tell me d address of your blog..I need script for practice
@Csharp-video-tutorialsBlogspot
4 жыл бұрын
Hello Ritike - The following is the text version of the video that contains the script you need. csharp-video-tutorials.blogspot.com/2014/05/part-5-sql-query-to-find-employees.html You can find all the SQL Server Interview Questions and Answers text articles in sequence on the following page. csharp-video-tutorials.blogspot.com/2014/05/sql-server-interview-questions-and.html All SQL Server tutorial articles are at the following link. csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html
Пікірлер: 74