Q.45 What are the use of WHERE clause in SQLite.?Ans:-
- By using WHERE clause in SQLite3 you can find particular name where its uniq identity or using WHERE clause you can get particular id information of object where the uniq name avilable.
- Basically use of this query whenever you want information about particular one employee and they have itself diffierent uniq identity just like mobile number, componey id, roll number so by using where clause if u find the uniq id ex.123 then give me information about 123 number id emploee.
- ex.
select * from table_name where field_name=123;
select filed_name from table_name where field_name=123;
swamios.com 