SQL - Part 16 - Limit Keyword

[@Nitish_Mehta]

Best SQL lecture series.*********9/10

[@QAFox]

Thank you :)

[@th3graduate292]

its 10/10

[@munirajub7818]

Sir your explanation is super ,I think I am lucky ,I got your video , It help me a lot to learn sql

[@QAFox]

Good to hear. Welcome :)

[@vanshajgoyal573]

you are very nice person and your method of explaining concept is very appreciable sir

[@QAFox]

Thank you :)

[@PrashantSharma-q5v]

Hi Sir, the limit keyword is not working. It's throwing 'Syntax error in FROM clause'.

[@sujanm9887]

select top 5 * from customers where country='germany'

[@Buzzme-in17]

Limit function is not working

[@naveenv3031]

yes same here

[@georgehatzimanolakis1904]

I am unable to use LIMIT in v1.6

[@sudhanshunandan7050]

I am using the same query but still getting the syntax error in FROM clause but the link you shared for the same query in the comment box working fine. why?

[@QAFox]

W3Schools are restricting something here. I too don't have an exact idea how they are restricting here.

[@sudhanshunandan7050]

@@QAFox so which server I should use to perform all the query??

[@QAFox]

@@sudhanshunandan7050 Use what every I am using the videos.

[@hariprasadmore2811]

Select TOP 3 from table name we can get 3 records so what is difference???

[@beharasrinivasulu3030]

this limit keyword doesn't work

[@amruthasankar3453]

Thankyou sir❤️🔥

[@QAFox]

Welcome :)

[@MHb789]

Sir i know the basics but not able to apply the logic to approach the problem step by step.How can I improve?

[@manisaipandugayala4779]

very nice videos is it possible embedded testing vidoes

[@QAFox]

I have few pending playlists to be created. After that will work on this.

[@harshpathak6645]

SELECT * from customers where country='usa' limit 5;(this shows syntax error(missing operator)in w3schools

[@akashbhandari7154]

Yes, it's showing error

[@shubhankarray8336]

@@akashbhandari7154 use SELECT TOP 5* instead

[@th3graduate292]

Thank You sir.

[@QAFox]

Welcome :)

[@aakritikhanduri8370]

sir my queries are not working in the site i donot know why this limit one

[@salmanshareef-q2i]

unable to use limit keyword in w3 sql version 6

[@QAFox]

Use specific page for this command try editor to run this command. Try it here - www.w3schools.com/mysql/trymysql.asp?filename=trysql_select_limit Note: Join our telegram group here - t.me/qafoxoriginal

[@rishabhgupta9828]

If I write select * from customer where country = 'usa' ....... It's show no result . I don't understand why this is happening if i use where with the numbers it works but not with the characters.

[@rishabhgupta9828]

I'm also using the same w3school sql ...

[@QAFox]

@@rishabhgupta9828 Try it here - www.w3schools.com/mysql/trymysql.asp?filename=trysql_select_limit

[@rishabhgupta9828]

@@QAFox now it's working. Thankyou sir.

[@QAFox]

@@rishabhgupta9828 Welcome :)

[@partabparmar5537]

thank you sir....!!!!

[@sonukosuno6803]

i watched a last session for wildcard when i try with integer value i was hitting issue does wildcard not work with integer value?

[@beharasrinivasulu3030]

bro its working on characters

[@sujanm9887]

for those whose limit aint working use top select top 5 * from customers where country='germany' the number depends on how many records you need