{"id":5884,"date":"2015-01-31T20:20:15","date_gmt":"2015-02-01T01:20:15","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=5884"},"modified":"2015-09-03T08:16:31","modified_gmt":"2015-09-03T12:16:31","slug":"sql-order-by-%e0%a6%95%e0%a7%80%e0%a6%93%e0%a7%9f%e0%a6%be%e0%a6%b0%e0%a7%8d%e0%a6%a1-sql-order-by-keyword","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=5884","title":{"rendered":"SQL ORDER BY \u0995\u09c0\u0993\u09df\u09be\u09b0\u09cd\u09a1 . SQL ORDER BY Keyword"},"content":{"rendered":"

SQL ORDER BY \u0995\u09c0\u0993\u09df\u09be\u09b0\u09cd\u09a1<\/h1>\n

Article By: Pratap Chandra<\/p>\n

\u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7\u09b0 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a5\u09c7\u0995\u09c7 \u09a4\u09c1\u09b2\u09c7 \u0986\u09a8\u09be \u09a1\u09be\u099f\u09be\u0995\u09c7 \u09aa\u09cd\u09b0\u09df\u09cb\u099c\u09a8 \u09ae\u09a4\u09cb \u09b8\u09be\u099c\u09be\u09a4\u09c7 ORDER BY \u0995\u09c0\u0993\u09df\u09be\u09b0\u09cd\u09a1 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u098f\u0995 \u0995\u09bf\u0982\u09ac\u09be \u098f\u0995\u09be\u09a7\u09bf\u0995 \u0995\u09b2\u09be\u09ae \u09a7\u09b0\u09c7 \u098f\u0987 \u0995\u09c0\u0993\u09df\u09be\u09b0\u09cd\u09a1\u09c7\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 \u09a1\u09be\u099f\u09be \u09b8\u09be\u099c\u09be\u09a8\u09cb \u09af\u09be\u09df \u098f\u09ac\u0982 \u09b8\u099c\u09cd\u099c\u09be\u09b0 \u09aa\u09cd\u09b0\u0995\u09c3\u09a4\u09bf (\u0989\u09b0\u09cd\u09a7\u09cd\u09ac\u0995\u09cd\u09b0\u09ae \u0995\u09bf\u0982\u09ac\u09be \u0985\u09a7:\u0995\u09cd\u09b0\u09ae) \u0989\u09b2\u09cd\u09b2\u09c7\u0996 \u09a8\u09be \u0995\u09b0\u09b2\u09c7 \u09b8\u09cd\u09ac\u09df\u0982\u0995\u09cd\u09b0\u09bf\u09ad\u09be\u09ac\u09c7 \u0989\u09b0\u09cd\u09a7\u09cd\u09ac\u0995\u09cd\u09b0\u09ae (ascending) \u0985\u09a8\u09c1\u09b8\u09be\u09b0\u09c7 \u09b8\u09be\u099c\u09be\u09df\u0964 \u09aa\u09cd\u09b0\u09be\u09aa\u09cd\u09a4 \u09a1\u09be\u099f\u09be\u0995\u09c7 \u0985\u09a7:\u0995\u09cd\u09b0\u09ae (descending) \u0985\u09a8\u09c1\u09b8\u09be\u09b0\u09c7 \u09b8\u09be\u099c\u09be\u09a4\u09c7 \u0997\u09c7\u09b2\u09c7 DESC \u0995\u09c0\u0993\u09df\u09be\u09b0\u09cd\u09a1 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964<\/p>\n

SQL ORDER BY \u09b8\u09bf\u09a8\u099f\u09cd\u09af\u09be\u0995\u09cd\u09b8<\/h3>\n

SELECT column_name<\/em>,column_name<\/em><\/p>\n

FROM table_name<\/em><\/p>\n

ORDER BY column_name<\/em>,column_name<\/em> ASC|DESC;<\/p>\n

\u098f\u0987 \u09b8\u09bf\u09a8\u099f\u09cd\u09af\u09be\u0995\u09cd\u09b8\u09c7 column_name <\/em>\u09ac\u09b2\u09a4\u09c7 \u09ac\u09c1\u099d\u09be\u09a8\u09cb \u09b9\u09df\u09c7\u099b\u09c7 \u0986\u09aa\u09a8\u09bf \u09af\u09c7\u099f\u09bf \u09ac\u09be \u09af\u09c7\u09b8\u09ac \u0995\u09b2\u09be\u09ae\u09c7\u09b0 \u09a1\u09be\u099f\u09be \u09a4\u09c1\u09b2\u09c7 \u0986\u09a8\u09a4\u09c7 \u099a\u09be\u09a8 \u09a4\u09be\u09b0 \u09a8\u09be\u09ae\u0964 table_name\u098f\u09b0 \u09b8\u09cd\u09a5\u09b2\u09c7 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7\u09b0 \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u099f\u09c7\u09ac\u09bf\u09b2\u09c7\u09b0 \u09a8\u09be\u09ae \u09b2\u09bf\u0996\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 ORDER BY \u098f\u09b0 \u09aa\u09b0 \u09b2\u09bf\u0996\u09a4\u09c7 \u09b9\u09ac\u09c7 \u0986\u09aa\u09a8\u09bf \u0995\u09cb\u09a8 \u0995\u09b2\u09be\u09ae \u09a7\u09b0\u09c7 \u0995\u09bf\u0982\u09ac\u09be \u0985\u0997\u09cd\u09b0\u09be\u09a7\u09bf\u0995\u09be\u09b0 \u0985\u09a8\u09c1\u09b8\u09be\u09b0\u09c7 \u0995\u09cb\u09a8 \u0995\u09b2\u09be\u09ae\u0997\u09c1\u09b2\u09cb \u09a7\u09b0\u09c7 \u09a1\u09be\u099f\u09be \u09b8\u09be\u099c\u09be\u09a4\u09c7 \u099a\u09be\u09a8\u0964 \u0989\u09b0\u09cd\u09a7\u09cd\u09ac\u0995\u09cd\u09b0\u09ae\u09c7 \u09b8\u09be\u099c\u09be\u09a4\u09c7 \u099a\u09be\u0987\u09b2\u09c7 ASC \u098f\u09ac\u0982 \u0985\u09a7:\u0995\u09cd\u09b0\u09ae \u0985\u09a8\u09c1\u09b8\u09be\u09b0\u09c7 \u09b8\u09be\u099c\u09be\u09a4\u09c7 \u099a\u09be\u0987\u09b2\u09c7 DESC \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964<\/p>\n

\u09a1\u09be\u099f\u09be \u09a8\u09bf\u09b0\u09cd\u09ac\u09be\u099a\u09a8\u09c7\u09b0 \u0989\u09a6\u09be\u09b9\u09b0\u09a3:<\/h3>\n

\u098f\u0987 \u099f\u09bf\u0989\u099f\u09bf\u09b0\u09bf\u09df\u09be\u09b2\u09c7 \u0986\u09ae\u09b0\u09be \u09ac\u09b9\u09c1\u09b2 \u09aa\u09b0\u09bf\u099a\u09bf\u09a4 Northwind \u09b8\u09cd\u09af\u09be\u09ae\u09cd\u09aa\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u099f\u09bf \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09ac, \u09af\u09c7\u099f\u09bf \u09ae\u09be\u0987\u0995\u09cd\u09b0\u09cb\u09b8\u09ab\u099f Excel \u098f\u09ac\u0982 MS SQL Server \u098f\u09b0 \u09b8\u09be\u09a5\u09c7 \u09b6\u09bf\u0995\u09cd\u09b7\u09be\u09b0\u09cd\u09a5\u09c0\u09a6\u09c7\u09b0 \u099c\u09a8\u09cd\u09af \u09a4\u09c8\u09b0\u09c0 \u0985\u09ac\u09b8\u09cd\u09a5\u09be\u09df (readymade) \u09b8\u0982\u09af\u09c1\u0995\u09cd\u09a4 \u0995\u09b0\u09be \u09a5\u09be\u0995\u09c7\u0964<\/p>\n

Northwind \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7\u09b0 Customers \u099f\u09c7\u09ac\u09bf\u09b2 \u09a5\u09c7\u0995\u09c7 \u0995\u09bf\u099b\u09c1 \u09a1\u09be\u099f\u09be \u09a8\u09bf\u09b0\u09cd\u09ac\u09be\u099a\u09a8 \u0995\u09b0\u09be \u09b9\u09b2\u09cb:<\/p>\n

AlfredsFutterkisteObereStr.57Ana TrujilloEmparedados yheladosAvda. de laConstituci\u00f3n2222M\u00e9xico D.F.Mataderos 2312M\u00e9xico D.F.WA1 1DPBerglundssnabbk\u00f6pBerguvsv\u00e4gen 8<\/p>\n\n\n\n\n\n\n\n\n
\n

CustomerID<\/strong><\/p>\n<\/td>\n

\n

CustomerName<\/strong><\/p>\n<\/td>\n

\n

ContactName<\/strong><\/p>\n<\/td>\n

\n

Address<\/strong><\/p>\n<\/td>\n

\n

City<\/strong><\/p>\n<\/td>\n

\n

PostalCode<\/strong><\/p>\n<\/td>\n

\n

Country<\/strong><\/p>\n<\/td>\n<\/tr>\n

1<\/td>\nMaria Anders<\/td>\nBerlin<\/td>\n12209<\/td>\nGermany<\/td>\n<\/tr>\n
2<\/td>\nAna Trujillo<\/td>\n05021<\/td>\nMexico<\/td>\n<\/tr>\n
3<\/td>\nAntonio Moreno Taquer\u00eda<\/td>\nAntonio Moreno<\/td>\n05023<\/td>\nMexico<\/td>\n<\/tr>\n
4<\/td>\nAround the Horn<\/td>\nThomas Hardy<\/td>\n120 Hanover Sq.<\/td>\nLondon<\/td>\nUK<\/td>\n<\/tr>\n
5<\/td>\nChristina Berglund<\/td>\nLule\u00e5<\/td>\nS-958 22<\/td>\nSweden<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

ORDER BY \u098f\u09b0 \u0989\u09a6\u09be\u09b9\u09b0\u09a3:<\/h3>\n

\u09a8\u09bf\u099a\u09c7\u09b0 SQL \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f\u099f\u09bf \u09aa\u09cd\u09b0\u09df\u09cb\u0997 \u0995\u09b0\u09b2\u09c7 Customers \u099f\u09c7\u09ac\u09bf\u09b2 \u09a5\u09c7\u0995\u09c7 \u09b8\u09ac customer \u098f\u09b0 \u09a4\u09a5\u09cd\u09af \u0989\u09a0\u09c7 \u0986\u09b8\u09ac\u09c7\u0964 \u0986\u09b0 \u098f\u0987 \u09a4\u09a5\u09cd\u09af\u0997\u09c1\u09b2\u09cb Country \u0995\u09b2\u09be\u09ae \u09a7\u09b0\u09c7 \u0989\u09a7\u09cd\u09ac\u09b0\u09cd\u0995\u09cd\u09b0\u09ae \u0985\u09a8\u09c1\u09b8\u09be\u09b0\u09c7 \u09b8\u09be\u099c\u09be\u09ac\u09c7\u0964<\/p>\n

SELECT * FROM Customers<\/p>\n

ORDER BY Country;<\/p>\n

ORDER BY DESC \u098f\u09b0 \u0989\u09a6\u09be\u09b9\u09b0\u09a3:<\/h3>\n

\u09a8\u09bf\u099a\u09c7\u09b0 SQL \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f\u099f\u09bf \u09aa\u09cd\u09b0\u09df\u09cb\u0997 \u0995\u09b0\u09b2\u09c7 Customers \u099f\u09c7\u09ac\u09bf\u09b2 \u09a5\u09c7\u0995\u09c7 \u09b8\u09ac customers \u098f\u09b0 \u09a4\u09a5\u09cd\u09af \u0989\u09a0\u09c7 \u0986\u09b8\u09ac\u09c7\u0964 \u098f\u0987 \u09a4\u09a5\u09cd\u09af\u0997\u09c1\u09b2\u09cb Country \u0995\u09b2\u09be\u09ae \u09a7\u09b0\u09c7 \u0985\u09a7:\u0995\u09cd\u09b0\u09ae \u0985\u09a8\u09c1\u09b8\u09be\u09b0\u09c7 \u09b8\u09be\u099c\u09be\u09ac\u09c7\u0964<\/p>\n

SELECT * FROM Customers<\/p>\n

ORDER BY Country DESC;<\/p>\n

\u098f\u0995\u09be\u09a7\u09bf\u0995 \u0995\u09b2\u09be\u09ae \u0985\u09a8\u09c1\u09b8\u09be\u09b0\u09c7 \u09a1\u09be\u099f\u09be \u09b8\u09be\u099c\u09be\u09a8\u09c7\u09be\u09b0 \u0989\u09a6\u09be\u09b9\u09b0\u09a3:<\/h3>\n

\u09a8\u09bf\u099a\u09c7\u09b0 SQL \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f\u099f\u09bf \u09aa\u09cd\u09b0\u09df\u09cb\u0997 \u0995\u09b0\u09b2\u09c7 Customers \u099f\u09c7\u09ac\u09bf\u09b2 \u09a5\u09c7\u0995\u09c7 \u09b8\u09ac customer \u098f\u09b0 \u09a4\u09a5\u09cd\u09af \u0989\u09a0\u09c7 \u0986\u09b8\u09ac\u09c7\u0964 \u09a4\u09ac\u09c7 \u098f\u0987 \u09a4\u09a5\u09cd\u09af\u0997\u09c1\u09b2\u09cb Country \u098f\u09ac\u0982 CustomerName \u0995\u09b2\u09be\u09ae \u09a7\u09b0\u09c7 \u09b8\u09be\u099c\u09be\u09ac\u09c7\u0964 \u09aa\u09cd\u09b0\u09a5\u09ae \u0985\u0997\u09cd\u09b0\u09be\u09a7\u09bf\u0995\u09be\u09b0 \u09aa\u09be\u09ac\u09c7 Country \u098f\u09ac\u0982 \u09a6\u09cd\u09ac\u09bf\u09a4\u09c0\u09df \u0985\u0997\u09cd\u09b0\u09be\u09a7\u09bf\u0995\u09be\u09b0 \u09aa\u09be\u09ac\u09c7 CustomerName\u0964<\/p>\n

SELECT * FROM Customers<\/p>\n

ORDER BY Country,CustomerName;<\/p>\n","protected":false},"excerpt":{"rendered":"

SQL ORDER BY \u0995\u09c0\u0993\u09df\u09be\u09b0\u09cd\u09a1 Article By: Pratap Chandra \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7\u09b0 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a5\u09c7\u0995\u09c7 \u09a4\u09c1\u09b2\u09c7 \u0986\u09a8\u09be \u09a1\u09be\u099f\u09be\u0995\u09c7 \u09aa\u09cd\u09b0\u09df\u09cb\u099c\u09a8 \u09ae\u09a4\u09cb \u09b8\u09be\u099c\u09be\u09a4\u09c7 ORDER BY \u0995\u09c0\u0993\u09df\u09be\u09b0\u09cd\u09a1 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u098f\u0995 \u0995\u09bf\u0982\u09ac\u09be \u098f\u0995\u09be\u09a7\u09bf\u0995 \u0995\u09b2\u09be\u09ae \u09a7\u09b0\u09c7 \u098f\u0987 \u0995\u09c0\u0993\u09df\u09be\u09b0\u09cd\u09a1\u09c7\u09b0 \u09b8\u09be\u09b9\u09be\u09af\u09cd\u09af\u09c7 \u09a1\u09be\u099f\u09be \u09b8\u09be\u099c\u09be\u09a8\u09cb \u09af\u09be\u09df \u098f\u09ac\u0982 \u09b8\u099c\u09cd\u099c\u09be\u09b0 \u09aa\u09cd\u09b0\u0995\u09c3\u09a4\u09bf (\u0989\u09b0\u09cd\u09a7\u09cd\u09ac\u0995\u09cd\u09b0\u09ae \u0995\u09bf\u0982\u09ac\u09be \u0985\u09a7:\u0995\u09cd\u09b0\u09ae) \u0989\u09b2\u09cd\u09b2\u09c7\u0996 \u09a8\u09be \u0995\u09b0\u09b2\u09c7 \u09b8\u09cd\u09ac\u09df\u0982\u0995\u09cd\u09b0\u09bf\u09ad\u09be\u09ac\u09c7 \u0989\u09b0\u09cd\u09a7\u09cd\u09ac\u0995\u09cd\u09b0\u09ae (ascending) \u0985\u09a8\u09c1\u09b8\u09be\u09b0\u09c7 \u09b8\u09be\u099c\u09be\u09df\u0964 \u09aa\u09cd\u09b0\u09be\u09aa\u09cd\u09a4 \u09a1\u09be\u099f\u09be\u0995\u09c7 \u0985\u09a7:\u0995\u09cd\u09b0\u09ae (descending) \u0985\u09a8\u09c1\u09b8\u09be\u09b0\u09c7 \u09b8\u09be\u099c\u09be\u09a4\u09c7 … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[155],"tags":[],"class_list":["post-5884","post","type-post","status-publish","format-standard","hentry","category------sql-001","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":5943,"url":"http:\/\/bangla.sitestree.com\/?p=5943","url_meta":{"origin":5884,"position":0},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) ALTER TABLE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f . SQL Alter Table Statement","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) ALTER TABLE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f Article By : Protap Chandra \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7 \u09ac\u09bf\u09a6\u09cd\u09af\u09ae\u09be\u09a8 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2\u09c7\u09b0 \u09aa\u09c1\u09b0\u09be\u09a4\u09a8 \u09a1\u09be\u099f\u09be\u09b0 \u09b8\u0999\u09cd\u0997\u09c7 \u09a8\u09a4\u09c1\u09a8 \u09a1\u09be\u099f\u09be \u09af\u09cb\u0997 \u0995\u09b0\u09a4\u09c7, \u09ac\u09b0\u09cd\u09a4\u09ae\u09be\u09a8 \u09a1\u09be\u099f\u09be \u09ae\u09c1\u099b\u09c7 \u09ab\u09c7\u09b2\u09a4\u09c7 \u0995\u09bf\u0982\u09ac\u09be \u0995\u09b2\u09be\u09ae\u09c7 \u0995\u09cb\u09a8\u09cb \u09a7\u09b0\u09a8\u09c7\u09b0 \u09aa\u09b0\u09bf\u09ac\u09b0\u09cd\u09a4\u09a8 \u0986\u09a8\u09a4\u09c7 ALTER TABLE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 SQL ALTER TABLE \u09b8\u09bf\u09a8\u099f\u09cd\u09af\u09be\u0995\u09cd\u09b8 (Syntax) ALTER TABLE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u09aa\u09b0\u09bf\u09ac\u09b0\u09cd\u09a4\u09a8 \u0986\u09a8\u09a4\u09c7\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5959,"url":"http:\/\/bangla.sitestree.com\/?p=5959","url_meta":{"origin":5884,"position":1},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) CREATE INDEX \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) CREATE INDEX \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f Article By : Protap Chandra \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8 \u09b6\u09ac\u09cd\u09a6\u09c7\u09b0 \u0985\u09b0\u09cd\u09a5 \u09b9\u09b2\u09cb \u09b8\u09c2\u099a\u09bf\u0995\u09b0\u09a3\u0964 \u09b8\u09b9\u099c\u09c7 \u0993 \u0995\u09ae \u09b8\u09ae\u09df\u09c7 \u09a1\u09be\u099f\u09be \u0996\u09c1\u0981\u099c\u09c7 \u09ac\u09c7\u09b0 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u09a1\u09be\u099f\u09be\u0995\u09c7 \u098f\u0995\u099f\u09bf \u09ac\u09bf\u09b6\u09c7\u09b7 \u0985\u09b0\u09cd\u09a1\u09be\u09b0\u09c7 \u09b8\u09be\u099c\u09bf\u09df\u09c7 \u09b0\u09be\u0996\u09be\u0995\u09c7 \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8\u09bf\u0982 \u09ac\u09b2\u09c7\u0964 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7\u09b0 \u09a1\u09be\u099f\u09be\u0995\u09c7 \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8\u09bf\u0982 \u0995\u09b0\u09a4\u09c7 CREATE INDEX \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u0987\u09a8\u09a1\u09c7\u0995\u09cd\u09b8 \u0995\u09b0\u09be \u09a5\u09be\u0995\u09b2\u09c7 \u0996\u09c1\u09ac \u09b8\u09b9\u099c\u09c7 \u09a1\u09be\u099f\u09be \u0996\u09c1\u0981\u099c\u09c7 \u09ac\u09c7\u09b0\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5882,"url":"http:\/\/bangla.sitestree.com\/?p=5882","url_meta":{"origin":5884,"position":2},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) WHERE \u0995\u09cd\u09b2\u099c . SQL WHERE Clause","author":"Author-Check- Article-or-Video","date":"January 31, 2015","format":false,"excerpt":"

SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) WHERE \u0995\u09cd\u09b2\u099c<\/h1> Article By: Pratap Chandra

\u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a5\u09c7\u0995\u09c7 \u09a1\u09be\u099f\u09be \u09ab\u09bf\u09b2\u09cd\u099f\u09be\u09b0 (filter) \u09ac\u09be \u09aa\u09b0\u09bf\u09b6\u09cb\u09a7\u09a8 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af WHERE \u0995\u09cd\u09b2\u099c \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u098f\u0996\u09be\u09a8\u09c7 \u09aa\u09b0\u09bf\u09b6\u09cb\u09a7\u09a8 \u0995\u09b0\u09be \u09ac\u09b2\u09a4\u09c7 \u09ac\u09c1\u099d\u09be\u09a8\u09cb \u09b9\u09df\u09c7\u099b\u09c7 \u09b6\u09b0\u09cd\u09a4 \u09aa\u09cd\u09b0\u09df\u09cb\u0997 \u0995\u09b0\u09c7 \u0995\u09c7\u09ac\u09b2 \u09aa\u09cd\u09b0\u09df\u09cb\u099c\u09a8\u09c0\u09df \u09a1\u09be\u099f\u09be\u0997\u09c1\u09b2\u09cb \u09a4\u09c1\u09b2\u09c7 \u0986\u09a8\u09be\u0964 \u0986\u09aa\u09a8\u09bf \u09af\u09c7 \u09b6\u09b0\u09cd\u09a4 \u09aa\u09cd\u09b0\u09df\u09cb\u0997 \u0995\u09b0\u09ac\u09c7\u09a8 \u09b6\u09c1\u09a7\u09c1 \u09b8\u09c7\u0987 \u09b6\u09b0\u09cd\u09a4 \u09aa\u09c2\u09b0\u09a3 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09be \u09a1\u09be\u099f\u09be\u0987 \u0995\u09c7\u09ac\u09b2 \u09ac\u09be\u099b\u09be\u0987\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5813,"url":"http:\/\/bangla.sitestree.com\/?p=5813","url_meta":{"origin":5884,"position":3},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) Syntax : SQL Syntax","author":"Author-Check- Article-or-Video","date":"January 21, 2015","format":false,"excerpt":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) Syntax Article By : Protap Chand \u0986\u099c \u0986\u09ae\u09b0\u09be \u09b6\u09bf\u0996\u09ac \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 (SQL) \u09b8\u09bf\u09a8\u099f\u09cd\u09af\u09be\u0995\u09cd\u09b8 \u09ac\u09be \u09ac\u09be\u0995\u09cd\u09af\u09b0\u09c0\u09a4\u09bf\u0964 \u09af\u09c7\u0995\u09cb\u09a8 \u09ad\u09be\u09b7\u09be\u09b0 \u09b6\u09ac\u09cd\u09a6\u09ad\u09be\u09a8\u09cd\u09a1\u09be\u09b0 \u09a8\u09bf\u09df\u09c7 \u09af\u09c7\u09ae\u09a8 \u098f\u0995\u099f\u09bf \u09a8\u09bf\u099c\u09b8\u09cd\u09ac \u09ac\u09be\u0995\u09cd\u09af\u09b0\u09c0\u09a4\u09bf \u0986\u099b\u09c7\u0964 \u09a4\u09c7\u09ae\u09a8 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u098f\u09b0 \u09b8\u09a0\u09bf\u0995\u09ad\u09be\u09ac\u09c7 \u09ab\u09b2\u09be\u09ab\u09b2 \u09aa\u09cd\u09b0\u09a6\u09be\u09a8 \u0995\u09b0\u09a4\u09c7 \u098f\u0995\u099f\u09be \u0997\u09a0\u09a8 \u09ac\u09be \u09ac\u09be\u0995\u09cd\u09af\u09b0\u09c0\u09a4\u09bf \u09ae\u09c7\u09a8\u09c7 \u099a\u09b2\u09a4\u09c7 \u09b9\u09df\u0964 \u0985\u09a8\u09cd\u09af\u09a5\u09be\u09df error \u09ac\u09be \u09ad\u09c1\u09b2 \u09b9\u09df\u09c7\u099b\u09c7 \u09ae\u09b0\u09cd\u09ae\u09c7 \u09ac\u09be\u09b0\u09cd\u09a4\u09be \u09aa\u09cd\u09b0\u09a6\u09b0\u09cd\u09b6\u09a8 \u0995\u09b0\u09ac\u09c7\u0964 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u098f\u0995\u099f\u09bf\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6095,"url":"http:\/\/bangla.sitestree.com\/?p=6095","url_meta":{"origin":5884,"position":4},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf – \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09b9\u09a4\u09c7 \u09a1\u09be\u099f\u09be \u09b8\u09bf\u09b2\u09c7\u0995\u09cd\u099f \u0995\u09b0\u09be (PHP Select Data From MySQL in Bangla)","author":"Author-Check- Article-or-Video","date":"February 19, 2015","format":false,"excerpt":"select statement \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u0995\u09cb\u09a8 \u09a1\u09be\u099f\u09be \u09b8\u09bf\u09b2\u09c7\u0995\u09cd\u099f \u0995\u09b0\u09c7 \u09a1\u09bf\u09b8\u09aa\u09cd\u09b2\u09c7 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af Sql syntax SELECT column_name(s) FROM table_name \u0985\u09a5\u09ac\u09be \u0986\u09ae\u09b0\u09be \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf SELECT * FROM table_name \u00a0 \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09a6\u09bf\u09df\u09c7 \u098f\u09b0 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u09ac\u09cb\u099d\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 \u09a8\u09bf\u099a\u09c7\u09b0 \u09ae\u09a4\u09a8 \u09ae\u09a8\u09c7 \u0995\u09b0\u09bf \u098f\u0987 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0\u2026","rel":"","context":"In "\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial"","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6261,"url":"http:\/\/bangla.sitestree.com\/?p=6261","url_meta":{"origin":5884,"position":5},"title":"\u099c\u09c7\u0995\u09cb\u09df\u09c7\u09b0\u09bf \u09ae\u09cb\u09ac\u09be\u0987\u09b2 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u099f\u09c7\u09ac\u09bf\u09b2 \u09b8\u09be\u099c\u09be\u09a8\u09cb \u0964","author":"Author-Check- Article-or-Video","date":"February 11, 2015","format":false,"excerpt":"\u099c\u09c7\u0995\u09cb\u09df\u09c7\u09b0\u09bf \u09ae\u09cb\u09ac\u09be\u0987\u09b2 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u099f\u09c7\u09ac\u09bf\u09b2 \u09b8\u09be\u099c\u09be\u09a8\u09cb \u0964 \u09b2\u09c7\u0996\u09be\u0983\u00a0 \u09ae\u09cb\u09b8\u09cd\u09a4\u09be\u09ab\u09bf\u099c\u09c1\u09b0 \u09ab\u09bf\u09b0\u09cb\u099c \u0964 \u09ae\u09c7\u0987\u09b2\u0983 me@firoz.me \u00a0 \u0986\u099c \u0986\u09ae\u09b0\u09be \u099c\u09c7\u0995\u09df\u09c7\u09b0\u09bf \u09ae\u09cb\u09ac\u09be\u0987\u09b2 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u09b0\u09c7\u09b8\u09cd\u09aa\u09a8\u09cd\u09b8\u09bf\u09ad \u099f\u09c7\u09ac\u09bf\u09b2 \u09ac\u09be\u09a8\u09be\u09a8\u09cb \u09b6\u09bf\u0996\u09ac\u09cb \u09af\u09be \u09b8\u0995\u09b2 \u09b8\u09be\u0987\u099c\u09c7\u09b0 \u09b8\u09cd\u0995\u09cd\u09b0\u09c0\u09a8\u09c7 \u09ad\u09be\u09b2\u09ad\u09be\u09ac\u09c7 \u09b8\u09be\u09aa\u09cb\u09b0\u09cd\u099f \u0995\u09b0\u09ac\u09c7 \u0964 \u00a0 \u09b0\u09c7\u09b8\u09cd\u09aa\u09a8\u09cd\u09b8\u09bf\u09ad \u099f\u09c7\u09ac\u09bf\u09b2(Responsive Tables): \u0986\u09aa\u09a8\u09bf \u09af\u0996\u09a8 \u0986\u09aa\u09a8\u09be\u09b0 \u09b8\u09be\u0987\u099f\u09c7\u09b0 \u09b8\u0995\u09b2 \u09aa\u09c7\u099c\u09c7\u09b0 \u09b8\u09ac \u0995\u09a8\u09cd\u099f\u09c7\u09a8\u09cd\u099f\u0995\u09c7 \u09b8\u0995\u09b2 \u09aa\u09cd\u09b0\u0995\u09be\u09b0 \u09a1\u09bf\u09ad\u09be\u0987\u09b8\u09c7 \u09a6\u09c7\u0996\u09be\u09a4\u09c7 \u099a\u09be\u09a8 \u09a4\u0996\u09a8\u2026","rel":"","context":"In "jQuery Mobile \u0964 \u099c\u09c7\u0995\u09c1\u098f\u09b0\u09bf \u09ae\u09cb\u09ac\u09be\u0987\u09b2"","block_context":{"text":"jQuery Mobile \u0964 \u099c\u09c7\u0995\u09c1\u098f\u09b0\u09bf \u09ae\u09cb\u09ac\u09be\u0987\u09b2","link":"http:\/\/bangla.sitestree.com\/?cat=176"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5884"}],"version-history":[{"count":2,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5884\/revisions"}],"predecessor-version":[{"id":5999,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5884\/revisions\/5999"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5884"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}